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_statsPosted by Daniel Short on Feb 5, 2009 at 10:18 AM | Categories: ColdFusion -