ALL_INDEXES¶
ALL_INDEXES displays information about indexes accessible to the current user.
Column | Type | Description |
---|---|---|
owner | character varying(64) | Index owner |
index_name | character varying(64) | Index name |
table_name | character varying(64) | Name of the table corresponding to the index |
uniqueness | Text | Whether the index is unique |
generated | character varying(1) | Whether the index name is generated by the system |
partitioned | character(3) | Whether the index has the property of the partition table |