DBA_INDEXES

DBA_INDEXES describes all indexes in the database. To gather statistics for this view, use the DBMS_STATS package. This view supports parallel partitioned index scans. Its columns (except for TABLE_TYPE) are the same as those in ALL_INDEXES.

See Also: “ALL_INDEXES”