Examining the Execution Plan of a SQL Statement

This section describes how to use the EXPLAIN PLAN feature with Oracle Query Window.

This section covers the following topics:

About EXPLAIN PLAN

Oracle Query Window functionality allows you to examine the execution plan that the database follows to execute a specified SQL statement. An execution plan is the sequence of operations Oracle performs to run the statement and is typically used by database experts to manually tune SQL statements. To automatically tune SQL statements, use SQL Tuning Advisor. See Tuning SQL in Query Window.

An execution plan, also known as EXPLAIN PLAN, displays execution plans chosen by the Oracle optimizer for the following statements:

  • SELECT

  • INSERT

  • UPDATE

  • DELETE

  • CREATE TABLE

  • CREATE INDEX

  • ALTER INDEX REBUILD

To use this feature, you must understand the details of EXPLAIN PLAN which are described in the following guides.

Oracle® Database Performance Tuning Guide 11g Release 1 (11.1)

Oracle® Database SQL Reference 11g Release 1 (11.1)

If you wish to modify the default EXPLAIN PLAN functionality, set the options in the EXPLAIN PLAN Options Page before you execute the EXPLAIN PLAN. Executing SQL Statements Using Oracle Query Window describes how to open a SQL statement.

Query Window Options Page | Using the Explain Plan Feature