Basic Execution Plan Concepts

  • Tony Hasler


Now that you know what the CBO is and what it does, you need to begin understanding how to interpret its output: the execution plan. You will often hear an execution plan referred to as an explain plan because the SQL explain plan statement is a key part of one the most important ways to view an execution plan. This chapter looks in detail at the explain plan statement and other ways of viewing execution plans.


Execution Plan Operation Table Bind Variable Operation Interact Adaptive Plan 
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.

Copyright information

© Tony Hasler 2014

Authors and Affiliations

  • Tony Hasler
    • 1
  1. 1.BurntislandUnited Kingdom

Personalised recommendations