Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have a fairly simple query using sys.dm_db_missing_index_group_stats that identifies missing indexes in my SQL Server database. This is pretty commonly used. My question is how do I identify which of these indexes are important and should be created and should I just create them all or are there any other secrets? Anything I specifically should look for in the avg_user_impact or avg_total_user_cost columns?

share|improve this question

migrated from Mar 27 '13 at 6:14

This question came from our site for professional and enthusiast programmers.

Kimberly Tripp did a few very good video's on Index Analysis that covered your question extremely well as part of the MCM Readiness videos.

Indexing Strategies Demo
Indexing Strategies
Index Analysis

Among other things she said DO NOT just create all of them. Review each one and compare it to your existing indexes, review it's cost etc. I highly recommend them and best of all they are free!

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.