alen teplitsky (7/23/2010)
bob.taylor (9/16/2008)
And in SQL Server 2008, it gets even easier. When you display an actual execution plan in SQL Server Management Studio query windows, you will receive a message in green indicating the missing index information!boB Taylor, MCA: Database
i think it's only in the R2 version. helped solve a performance problem a few weeks ago. for some reason devs think their queries are some state secret and it's a PITA troubleshooting problems
SQL 2008 does it (management studio, it doesn't depend on the server version, just the version of the tools)
The information is in the XML plan in both 2005 and 2008, it's just that the 2008 management studio exposes it.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability