Skip to content
  • There are no suggestions because the search field is empty.

T SQL Script: Azure SQL Find Missing Indexes

T SQL Script: Azure SQL Find Missing Indexes

-- Azure SQL Find Missing Indexes
SELECT TOP 20
    mig.index_group_handle,
    mid.index_handle,
    mid.statement AS TableName,
    mid.equality_columns,
    mid.inequality_columns,
    mid.included_columns,
    migs.user_seeks,
    migs.user_scans,
    migs.avg_total_user_cost,
    migs.avg_user_impact
FROM sys.dm_db_missing_index_groups mig
JOIN sys.dm_db_missing_index_group_stats migs 
    ON mig.index_group_handle = migs.group_handle
JOIN sys.dm_db_missing_index_details mid 
    ON mig.index_handle = mid.index_handle
ORDER BY migs.avg_user_impact DESC;