SQL Server Eksik İndeks Önerileri (Missing Index DMV)

SELECT TOP 20
       ROUND(gs.avg_total_user_cost * gs.avg_user_impact * (gs.user_seeks + gs.user_scans), 0) AS improvement_score,
       DB_NAME(mid.database_id) AS db_name,
       mid.statement AS table_name,
       mid.equality_columns, mid.inequality_columns, mid.included_columns,
       gs.user_seeks, gs.user_scans, gs.avg_user_impact
FROM sys.dm_db_missing_index_group_stats gs
JOIN sys.dm_db_missing_index_groups mig ON mig.index_group_handle = gs.group_handle
JOIN sys.dm_db_missing_index_details mid ON mid.index_handle = mig.index_handle
ORDER BY improvement_score DESC;