denrepo

SQL ServerIndexes

Missing index suggestions

The optimizer's own index wish list, ranked by estimated benefit. Treat as leads, not instructions: overlapping suggestions are common.

Not yet verified. How scripts are tested

b-mssql-missing.sql
1SELECT TOP (25)2       DB_NAME(mid.database_id) AS database_name,3       mid.statement AS table_name,4       mid.equality_columns, mid.inequality_columns, mid.included_columns,5       migs.user_seeks, migs.avg_user_impact,6       CAST(migs.user_seeks * migs.avg_total_user_cost * migs.avg_user_impact / 100.07            AS DECIMAL(18,2)) AS improvement_score8FROM sys.dm_db_missing_index_groups mig9JOIN sys.dm_db_missing_index_group_stats migs ON migs.group_handle = mig.index_group_handle10JOIN sys.dm_db_missing_index_details mid ON mid.index_handle = mig.index_handle11ORDER BY improvement_score DESC;

Paste it into your query tool.

Open in denrepo

More SQL Server scripts: Indexes