For performance analysis it is important to, find, read and understand the content of an execution plan.
This page is supposed to collect information regarding explain plan and execution plans.
We use explain plan to get an execution plan.
is a tool or a function delivered by the DBMS (database management system) which makes an execution plan visible.
You can find the expain plan function in the Performance Trace (ST05) and the database performance monitor (ST04).
also called access plan is a parsed, optimized, compiled and executable SQL statement stored inside the database.
Using explain plan the SQL execution flow of this plan can be made visible textual or graphically. The execution
plan shows the detailed steps that are necessary to execute an SQ or DML statement.
Explaining the Explain Plan - Basics
Explaining the explain plan for DB6 - Basics Part 1
Explaining the explain plan for DB6 - Basics Part 2