How to read and analyze execution plans
If you are dealing with MSSql then you have probably at one point in you life run into the SQL Query Analyzer. It is a great tool to help you investigate and analyze your queries and to figure our how to optimized them. I must admit that I don`t use the tool very often, but not long ago, I was assigned to a task where I had to figure out why a single web page was causing the sql server to timeout. I started the Analyzer and narrowed the problem down to a single query.
Understanding how to read the execution plans can be a bit tricky so I found some great resources that can provide some understanding.
Execution Plan Basics
http://www.simple-talk.com/sql/performance/execution-plan-basics/
Graphical Execution Plans for Simple SQL Queries
http://www.simple-talk.com/sql/performance/graphical-execution-plans-for-simple-sql-queries/
Recent Posts