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;