USER_PART_INDEXES
USER_PART_INDEXES displays information about partitioned table indexes accessible to the current user.
Name |
Type |
Description |
---|---|---|
index_owner |
character varying(64) |
Name of the owner of the partitioned table index |
schema |
character varying(64) |
Schema of the partitioned table index |
index_name |
character varying(64) |
Name of the partitioned table index |
table_name |
character varying(64) |
Name of the partitioned table to which the partitioned table index belongs |
partitioning_type |
text |
Partition policy of the partitioned table
NOTE:
Currently, only range partitioning and list partitioning are supported. |
partition_count |
bigint |
Number of index partitions of the partitioned table index |
def_tablespace_name |
name |
Tablespace name of the partitioned table index |
partitioning_key_count |
integer |
Number of 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