Take the 2-minute tour ×
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. It's 100% free, no registration required.

I'm digging into sys.dm_db_index_usage_stats and finding that a number of our indexes are used exclusively in user_scans, not user_seeks. Does this imply that the index is useless and should be redesigned?

Thanks!

share|improve this question
add comment

1 Answer

up vote 4 down vote accepted

Not useless, but maybe sub-optimal. Scanning a 10 MB index is a hell of a lot faster than scanning a 1 GB table, though a seek would be even better. Can you tell us more about the indices? How are the tables being used?

share|improve this answer
    
Great point! I am just starting to examine a variety of databases we have around here to make some suggestions on where things can be improved - I will be digging deeper... and probably posting more questions. :) –  JHFB Mar 7 '12 at 18:57
add comment

Your Answer

 
discard

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.