dcsimg
LinkedIn
Twitter
RSS Feed
Download our iPhone app
TODAY'S HEADLINES  |   ARTICLE ARCHIVE  |   FORUMS  |   TIP BANK
Browse DevX
Sign up for e-mail newsletters from DevX


advertisement
 

Tip: Using sys.dm_db_missing_index_group_stats

See how to return summary information about groups of missing indexes, excluding spatial indexes.


advertisement

Using sys.dm_db_missing_index_group_stats returns summary information about groups of missing indexes, excluding spatial indexes. An example follows:

SELECT TOP 5 *  
FROM sys.dm_db_missing_index_group_stats  
ORDER BY avg_total_user_cost * avg_user_impact * (user_seeks + user_scans)

The above query determines which 5 missing indexes would produce the highest anticipated cumulative improvement.

 

Visit the DevX Tip Bank

 



   
Email AuthorEmail Author
Close Icon
Thanks for your registration, follow us on our social networks to keep up-to-date