MY_PART_INDEXES

MY_PART_INDEXES displays information about partitioned table indexes accessible to the current user. This view exists in both PG_CATALOG and SYS schema.

**Table 1** MY_PART_INDEXES columns
Name	Type	Description
def_tablespace_name	name	Tablespace name of a partitioned table index
index_owner	character varying(64)	Owner name of a partitioned table index
index_name	character varying(64)	Name of a partitioned table index
partition_count	bigint	Number of index partitions of a partitioned table index
partitioning_key_count	integer	Number of partition keys of a partitioned table
partitioning_type	text	Partitioning policy of a partitioned table NOTE: For details about the supported partitioning policies of the current partitioned table, see CREATE TABLE PARTITION.
schema	character varying(64)	Schema of a partitioned table index
table_name	character varying(64)	Name of the partitioned table to which a partitioned table index belongs
subpartitioning_type	text	Partitioning policy of a level-2 partitioned table. If the partitioned table is a level-1 partitioned table, NONE is displayed. NOTE: For details about the supported partitioning policies of the current level-2 partitioned table, see CREATE TABLE SUBPARTITION.
def_subpartition_count	integer	Default number of level-2 partitions to be created. The value is 1 for a level-2 partitioned table and 0 for a level-1 partitioned table.
subpartitioning_key_count	integer	Number of level-2 partition keys of the partitioned table.