Press "Enter" to skip to content

Tracking Column Indexes in Oracle

David Fitzjarrell is looking for a speedup:

There may be times when the DBA wants, or needs, to know:

  • What indexes are created against a given table
  • How those indexes are built

Such information is critical to performance tuning or discovering why, when an index exists, it isn’t used. Let’s dig into this and see what we find.

Click through for some sample queries.

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.