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

2 Comments

  1. John Benes

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

    Reply
    • SteveStedman

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

      -Steve

      Reply

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.