• 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