Find missing index in SQL Server

Updated on August 27, 2022     Kisan Patel

Here are the scripts for find missing index in SQL Server database:

SELECT  s.last_user_seek,
	d.object_id,
	d.equality_columns,
	d.included_columns,
	d.statement,
	s.avg_user_impact
FROM sys.dm_db_missing_index_group_stats AS s
        INNER JOIN sys.dm_db_missing_index_groups AS g ON (s.group_handle = g.index_group_handle)
	INNER JOIN sys.dm_db_missing_index_details AS d ON (g.index_handle = d.index_handle)

When you execute above it return information about the database table columns that are missing for an index.

More Reference:

• Find SQL Server Missing Indexes with DMVs/
• SQL SERVER – Missing Index Script – Download