Feb
5
2009
Finding Missing Indexes
I learned yesterday that SQL Server will tell me which indexes it thinks I need to have. Just use these three queries to get a look at what your SQL Server thinks you should be doing to take care of your queries
select * from sys.dm_db_missing_index_details
select * from sys.dm_db_missing_index_groups
select * from sys.dm_db_missing_index_group_stats