MY_PART_INDEXES
MY_PART_INDEXES displays information about partitioned table indexes accessible to the current user. This view exists in both the PG_CATALOG and SYS schemas.
| 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. |
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.
