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 '%_Document233%'
- OR statement LIKE '%_AccumRgTn11332%'
- OR statement LIKE '%_AccumRgT10549%'
- OR statement LIKE '%_Reference98%'
- OR statement LIKE '%_InfoRg11709%'
- OR statement LIKE '%_Reference21_VT782%'
- OR statement LIKE '%_InfoRg11710%'
- OR statement LIKE '%_InfoRg11715%'
- OR statement LIKE '%_AccumRgT10349%'
- OR statement LIKE '%_AccumRg10339%'
- OR statement LIKE '%_AccumRgT10337%'
- OR statement LIKE '%_AccumRg14026%'
- ORDER BY [TableName] ASC, [Total Cost] DESC
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement