How can you find the missing indexes that are needed to potentially improve the performance of your queries?

 

• The Missing Index Details option in the query execution plan, if available.
• The sys.dm_db_missing_index_details dynamic management view, that returns detailed information about missing indexes, excluding spatial indexes,
• A combination of the SQL Server Profiler and the Database Engine Tuning Advisor tools.