Skip to content

Instantly share code, notes, and snippets.

What would you like to do?
--Returns detailed information about missing indexes
SELECT * FROM sys.dm_db_missing_index_details
--Returns information about what missing indexes are contained in a specific missing index group
SELECT * FROM sys.dm_db_missing_index_groups
--Returns summary information about groups of missing indexes
SELECT * FROM sys.dm_db_missing_index_group_stats
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment