Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT
- [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 COLUMNS] = 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
- statement LIKE '%AccRgED636%'
- OR statement LIKE '%AccRg614%'
- OR statement LIKE '%InfoRg9712%'
- OR statement LIKE '%AccumRg10678%'
- OR statement LIKE '%AccumRg11289%'
- ORDER BY [Total Cost] DESC;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement