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 |
partition_count |
bigint |
Number of index partitions of the partitioned table index |
def_tablespace_name |
name |
Name of the tablespace 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