Index suggestions
Last updated:
Warning: Review and test in a non-production environment before running.
SELECT det.database_id, det.object_id,
DB_NAME(det.database_id) as [database_name], OBJECT_NAME(det.object_id, database_id) AS [object_name],
grp.user_seeks, grp.user_scans,
det.equality_columns, det.inequality_columns, det.included_columns, det.statement
FROM sys.dm_db_missing_index_details det
INNER JOIN sys.dm_db_missing_index_groups link ON det.index_handle = link.index_handle
LEFT OUTER JOIN sys.dm_db_missing_index_group_stats AS grp ON link.index_group_handle = grp.group_handle
WHERE det.database_id >= 5
ORDER BY [database_name], [object_name]
GO