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:

• Explaining and Displaying Execution Plans
  Knowledge of how to explain a statement and display its plan is essential to SQL tuning.
• PLAN_TABLE Reference
  This chapter describes PLAN_TABLE columns.