MY_PART_INDEXES

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

**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)	Name of the owner of a partitioned table index.
index_name	character varying(64)	Name of a partitioned table index.
partition_count	bigint	Number of index partitions of the partitioned table index.
partitioning_key_count	integer	Number of partition keys of a partitioned table.
partitioning_type	text	Partition 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 the partitioned table index belongs.