How to know unused indexes in a table.?

Parag Patel Parag Patel

Parag Patel

Entrepreneur | Student of Life Time | Database Engineer | MS SQL DBA AZURE Mentor | Career Coach | Investor | Nutritional Therapist | Risk Takers | Problem Solver | Consultant

Published May 8, 2020
+ Follow

By using a DMV we‘ll find the unused indexes details. We have a DMV called “sys.dm_db_index_usage_stats” which retrieves the statistics of indexes , if an index id is not in that dmv then we can say that index is not been using from a long time.

To view or add a comment, sign in

More articles by Parag Patel

See all articles

Insights from the community

Others also viewed

Explore topics