Check whether your indexes are actually used — the index usage stats DMV, finding unused and most valuable indexes, when each was last used, operational stats, and generating drop scripts.
Loading content...