Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I'm looking for a good, well-written and explained guide on reading and comparing execution plans in SQL Server. This is for more my own edification as well as for sharing with others.

If you want to add your own summary here that would be welcome, though I expect the topic is large enough that links to pre-written articles will be required. The more the merrier.

Update:
After much searching, I found this question as well:
http://stackoverflow.com/questions/333383/any-guides-on-learning-how-to-interpret-a-sql-querys-execution-plan-in-sql-serve/333410

However, that only has a single answer and it points to 181 page pdf file. While I will go through that, I'm looking for more of a guide; not a reference manual.

share

migration rejected from stackoverflow.com May 12 at 16:57

This question came from our site for professional and enthusiast programmers. Votes, comments, and answers are locked due to the question being closed here, but it may be eligible for editing and reopening on the site where it originated.

closed as too broad by Paul White, Mark Storey-Smith, Phil, bluefeet, Max Vernon May 12 at 16:57

There are either too many possible answers, or good answers would be too long for this format. Please add details to narrow the answer set or to isolate an issue that can be answered in a few paragraphs.If this question can be reworded to fit the rules in the help center, please edit the question.

    
Please see stackoverflow.com/questions/1693611/…, which I've flagged for here –  gbn Feb 8 '12 at 7:57
comments disabled on deleted / locked posts