Please can anyone explain How to read a Execution Plan for Poorly Performed Query in SQL Server?
views:
115answers:
2
+1
Q:
Please can anyone explain How to read a Execution Plan for Poorly Performed Query in SQL Server?
A:
- look at the diagram; it is a data-flow diagram showing the the basic operations (index scans, table scans, hashtable merges, et al) being performed
- find the section(s) with the highest percentage(s)
- think about what you can do to optimize that operation (hint: "add an index" is the most common solution)
post specific questions here if necessary
Steven A. Lowe
2009-04-12 21:55:25
+1
A:
Check out some of the MANY resources on execution plans on the web, e.g.:
Go to http://www.simple-talk.com and search for execution plans - there are many more articles and samples and even a free e-book on execution plans.
Marc
marc_s
2009-04-13 08:18:18
The simple talk article is very good, even if you have experience.
gbn
2009-04-13 09:33:00