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.