1003
Chapter 44: Interpreting Query Execution Plans
44
SQL Server Management Studio does a good job at exposing execution plan internals, which
allows you to dig deeply into the inner workings of the plan the Optimizer creates. Getting
a feel for the logic behind the different tasks that an execution plan involves, coupled with
the logic used behind these operations, is a huge step toward being a well-rounded PTO
professional.This chapter covered a small set of basics that you should be familiar with for tuning data-
base systems. The more exposure you have, and the more frequently you work with execu-
tion plans and tuning queries, the better you prepare yourself for solving your company’s
performance problems when they crop up — and performance problems always happen.The next chapter transitions into the whys and wherefores of query execution plans and
how to manipulate them with indexes — an execution plan one-two punch.c44.indd 1003c44.indd 1003 7/31/2012 10:19:29 AM7/31/2012 10:19:29 AM
http://www.it-ebooks.info