Indexes
These views provide information about indexes and indexed columns:
- DBA_IND_COLUMNS
Lists all indexed columns.
- DBA_INDEXES
Lists all indexes.
- INDEX_HISTOGRAM
Contains information about the distribution of index keys within the table. Populated for one index at a time by the ANALYZE INDEX ... VALIDATE STRUCTURE command.
- INDEX_STATS
Contains information about the structure of an index. Populated for one index at a time by the ANALYZE INDEX ... VALIDATE STRUCTURE command.
Get Oracle Database Administration: The Essential Refe now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.