If a query has suboptimal performance, the execution plan is the key tool for understanding the problem and supplying a solution.

This part contains the following chapters:

• Generating and Displaying Execution Plans
  A thorough understanding of execution plans is essential to SQL tuning.
• Reading Execution Plans
  Execution plans are represented as a tree of operations.