bibi92
asked on
DMV and Create missing indexes
Hello,
I have executed a query that use dmv for finding missing indexes.
SELECT TOP 25
[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_gr oups g
INNER JOIN sys.dm_db_missing_index_gr oup_stats s
ON s.group_handle = g.index_group_handle
INNER JOIN sys.dm_db_missing_index_de tails d
ON d.index_handle = g.index_handle
ORDER BY [Total Cost] DESC;
Does I have to create the index with the columns in the equality_usage?
Thanks
bibi
I have executed a query that use dmv for finding missing indexes.
SELECT TOP 25
[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_gr
INNER JOIN sys.dm_db_missing_index_gr
ON s.group_handle = g.index_group_handle
INNER JOIN sys.dm_db_missing_index_de
ON d.index_handle = g.index_handle
ORDER BY [Total Cost] DESC;
Does I have to create the index with the columns in the equality_usage?
Thanks
bibi
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks bibi
MissingIndexes.xls