Good question, I guess I misunderstood exactly what you were asking the first time. One thing I think I'd do in this instance is run a query like this:
SELECT
DDMID.index_handle,
DDMID.database_id,
DDMID.[object_id],
DDMID.equality_columns,
DDMID.inequality_columns,
DDMID.included_columns,
DDMID.statement,
DDMIGS.unique_compiles,
DDMIGS.user_seeks,
DDMIGS.user_scans,
DDMIGS.last_user_seek,
DDMIGS.last_user_scan,
DDMIGS.avg_total_user_cost,
DDMIGS.avg_user_impact,
DDMIGS.system_seeks,
DDMIGS.system_scans,
DDMIGS.last_system_seek,
DDMIGS.last_system_scan,
DDMIGS.avg_total_system_cost,
DDMIGS.avg_system_impact
FROM
sys.dm_db_missing_index_groups AS DDMIG JOIN
sys.dm_db_missing_index_group_stats AS DDMIGS
ON DDMIG.index_group_handle = DDMIGS.group_handle JOIN
sys.dm_db_missing_index_details AS DDMID
ON DDMIG.index_handle = DDMID.index_handle
Where
DDMID.database_id = DB_ID('yourdbname')
ORDER BY
DDMIGS.user_seeks DESC,
DDMIGS.avg_user_impact desc
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question