Registration

Dear SAP Community Member,
In order to fully benefit from what the SAP Community has to offer, please register at:
http://scn.sap.com
Thank you,
The SAP Community team.
Skip to end of metadata
Go to start of metadata

Explain Plan

Further Reading

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.

Explain 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).

Execution plan
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.

Blogs:

Explaining the Explain Plan - Basics

Explaining the explain plan for DB6 - Basics Part 1
Explaining the explain plan for DB6 - Basics Part 2

Books:
ABAP Performance Tuning - English
ABAP Performance Tuning - German

  • No labels