by dotnetpete
23. April 2009 10:55
Came across a very handy feature of the actual and estimated query plans today. When I ran the query I was tuning at the top of the query plan window underneath the query, the following text appeared:
Missing Index Details from Queries 2.sql
The Query Processor estimates that implementing the following index could improve the query cost by 88.9016%.
If I right clicked I got the option to choose the "Missing Index Details..." option which opened a new query window with the index create statement ready to run (I just had to supply the index name).
It was smart enough to suggest index columns and included columns for the index as well.
Subscribe