Missing Indexes Dynamic Management Views SQL Server includes a set of dynamic management views which tell you what indexes the SQL Server database engine thinks need to be added. These dynamic ...

SQL Server 2008 R2 also supports table partitioning ... use the following dynamic management views: sys.dm_db_missing_index_groups sys.dm_db_missing_index_details sys.dm_db_missing_index_group ...