How to find missing indexes in SQL Server

This works in SQL Server 2005 or better.

SELECT * FROM sys.dm_db_missing_index_details

Too easy!

See this link for more information.

This entry was posted in Microsoft. Bookmark the permalink.

Comments are closed.