Tuesday, August 14, 2012

Where to obtain informations about indexes

  • DBA_INDEXES: Provides information on the indexes
  • DBA_IND_COLUMNS: Provides information on the columns indexed
  • DBA_IND_EXPRESSIONS: Provides information on function based indexes
  • V$OBJECT_USAGE: Provides information on the usage of an index
Posted by at
Labels: , , ,

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)