Using SQL Server DMVs to Identify Missing Indexes

Using SQL Server DMVs to Identify Missing Indexes
The dynamic management views are:

- sys.dm_db_missing_index_details - Returns detailed information about a missing index
- sys.dm_db_missing_index_group_stats - Returns summary information about missing index groups
- sys.dm_db_missing_index_groups - Returns information about a specific group of missing indexes
- sys.dm_db_missing_index_columns(index_handle) - Returns information about the database table columns that are missing for an index. This is a function and requires the index_handle to be passed.

http://www.mssqltips.com/tip.asp?tip=1634