Select Page

Unused Indexes

The unused indexes page shows you the largest indexes in your database that are not being used.  With a bit of research you can usually free up space and eliminate waste by tracking these down and deleting them.

SQL Server unused indexes report

More Details… The Unused Indexes Advisor.

Related Links


  1. John Benes

    How do you determine if an index is unused?
    Thank you,

    • SteveStedman

      An unused index is an index that has had no seeks, scans, or lookups since the last SQL Server restart.



Submit a Comment

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

To prove you are not a robot: * Time limit is exhausted. Please reload CAPTCHA.