Feedback

SQL Server 2005 suggested missing indexes also but it wasn't displayed quite the same way. If you open the properties window and highlight the top level select of that above plan from SSMS 2005 against SQL 2005 you should see the list of suggested indexes with an impact number.

Always check if the suggestion makes sense. In my case, adding it made no significant difference, and it still complained of a missing index after I added it.

Check the query plans, do the math and determine if there is a need or not. In our app, (oltp type app), adding yet another index would most likely be deterimental to the transaction day-to-day operational side. Need to check all this carefully before accepting a machine's suggestion.

For me, when I use this with large queries, when I try to hover over or right-click on the missing index message the Microsoft SQL Management Studio hangs/crashes for like 15 seconds before it brings up a right-click menu. This seems to have something to do with it trying to display the query in a pop-up/overlay balloon. Does anyone know if there is a way to fix that or just turn that ballooon option off?