Monthly Archives: October 2015

MS SQL – Missing Index

SELECT id.index_handle, DB_NAME(id.database_id), id.object_id, id.statement AS object_name, gs.avg_user_impact, gs.avg_total_user_cost, id.equality_columns, id.inequality_columns, id.included_columns, gs.unique_compiles, gs.user_seeks, gs.last_user_seek, gs.last_system_seek, gs.user_scans, gs.last_user_scan, gs.system_scans FROM sys.dm_db_missing_index_details AS id INNER JOIN sys.dm_db_missing_index_groups AS g ON id.index_handle = g.index_handle INNER JOIN sys.dm_db_missing_index_group_stats AS gs ON g.index_group_handle = … Continue reading

Posted in Uncategorized | Leave a comment