Chapter 3
Basic Execution Plan Concepts
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.
But there is little point in displaying execution plans if you can’t understand what is displayed, and I will explain the process of interpreting execution plans in this chapter. Unfortunately, some ...
Get Expert Oracle SQL now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
