Missing Indexes ?

SELECT   object_name(mid.object_id) AS TableName,

         migs.user_seeks            AS Seeks,

         mid.equality_columns       AS Equality,

         mid.inequality_columns     AS Inequality,

         mid.included_columns       AS Included,

         mid.statement              AS [Statement]

FROM     sys.dm_db_missing_index_details mid

         JOIN sys.dm_db_missing_index_groups mig

           ON mid.index_handle = mig.index_handle

         JOIN sys.dm_db_missing_index_group_stats migs

           ON migs.group_handle = mig.index_group_handle

WHERE    database_id = db_id()

ORDER BY TableName

GO