ADM_PART_INDEXES
ADM_PART_INDEXES stores information about all partitioned table indexes (excluding global indexes of partitioned tables) in the database. By default, only the system administrator can access this view. Common users can access the view only after being authorized. This view exists in both PG_CATALOG and SYS schema.
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 the partitioned table. |
partitioning_type |
text |
Partitioning policy of the partitioned table.
NOTE:
For details about the supported partitioning policies of the current partitioned table, see CREATE TABLE PARTITION. |
schema |
character varying(64) |
Name of the schema to which a partitioned table index belongs. |
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 level-2 partition tables and 0 for level-1 partition tables. |
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.See the reply and handling status in My Cloud VOC.
For any further questions, feel free to contact us through the chatbot.
Chatbot