DBA_INDEXES¶
DBA_INDEXES displays all indexes in the database. This view is accessible only to users with system administrator rights.
Name | Type | Description |
|---|---|---|
owner | character varying(64) | Owner of the index |
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 a unique index |
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 |