SET STATISTICS XML ON
[put your query here]
SET STATISTICS XML OFF
Once you run that, in the results pane there's a "Microsoft SQL Server 2005 XML Showplan" with XML. Double-click on it - it'll open a new tab in SSMS with the XML broken out. Search for "Missing" - there will be a block entitled "Missing Indexes". It has the INEQUALITY columns, the EQUALITY columns, and the INCLUDEs that it wants.
It may be old news to some of you, but it's one of those things I hadn't played with until recently, and I'm really impressed with.
No comments:
Post a Comment