Updated on 2026-09-23 GMT+08:00

DBA_INDEXES

DBA_INDEXES displays all indexes in the database. Only users with system administrator permissions can access this view.

**Table 1** DBA_INDEXES columns
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

Parent Topic: System Views