Indexes Data Dictionary Views - Part 3 Posted by MOHAMMED ABDUL HAMEED on 4:54 AM

DBA_INDEXES : DBA view describes indexes on all tables in the database.

ALL_INDEXES : ALL view describes indexes on all tables accessible to the user.

USER_INDEXES : USER view is restricted to indexes owned by the user. 

INDEX_STATS : Stores information from the last ANALYZE INDEX...VALIDATE STRUCTURE statement.

INDEX_HISTOGRAM : Stores information from the last ANALYZE INDEX...VALIDATE STRUCTURE statement.