Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- -- отсутствующие индексы, вызывающие издержки
- SELECT TOP 10
- [Total Cost] = ROUND(avg_total_user_cost * avg_user_impact * (user_seeks + user_scans),0),
- avg_user_impact,
- TableName = statement,
- [EqualityUsage] = equality_columns,
- [InequalityUsage] = inequality_columns,
- [Include Cloumns] = included_columns
- FROM sys.dm_db_missing_index_groups g
- INNER JOIN sys.dm_db_missing_index_group_stats s ON s.group_handle = g.index_group_handle
- INNER JOIN sys.dm_db_missing_index_details d ON d.index_handle = g.index_handle
- WHERE database_id = DB_ID()
- ORDER BY [Total Cost] DESC;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement