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.
More Details… The Unused Indexes Advisor.
Related Links
- Unused Indexes Advisor
- Database Health Monitor Free Download
- Steve Stedman Blog
- Stedman Solutions, LLC
Enroll Today!
Steve and the team at Stedman Solutions are here for all your SQL Server needs.
Contact us today for your free 30 minute consultation..
We are ready to help!
Hi,
How do you determine if an index is unused?
Thank you,
John
An unused index is an index that has had no seeks, scans, or lookups since the last SQL Server restart.
-Steve