DBA_INDEXES¶
DBA_INDEXES displays all indexes in the database. This view is accessible only to users with system administrator rights.
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 |