O'Reilly logo

Oracle in a Nutshell by David C. Kreines, Rick Greenwald

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

PLAN_TABLE Columns

The information gathered from the EXPLAIN PLAN statement is stored in the PLAN_TABLE table or another table as specified in the command. This table contains the following columns. Each column description also shows the column’s datatype (e.g., VARCHAR2, DATE, etc.).

STATEMENT_ID

Identifies the information for a particular statement. VARCHAR2(30).

TIMESTAMP

Time the EXPLAIN PLAN was run. DATE.

REMARKS

Contains any remarks you want to add to a row. VARCHAR2(80).

OPERATION

The first row in the PLAN_TABLE contains one of the following values:

DELETE STATEMENT
INSERT STATEMENT
SELECT STATEMENT
UPDATE STATEMENT

Subsequent rows in the PLAN_TABLE contain a combination for this column and the OPTION column, which are listed in Table 17-3. VARCHAR2(30).

OPTION

Describes variations on the OPERATION column. VARCHAR2(225). The value pairs for these two columns are shown in Table 17-3.

Table 17-3. OPERATION and OPTION values

OPERATION

OPTION

Meaning

AND-EQUAL

Intersection of sets of data.

BITMAP

CONVERSION (TO ROWIDS | FROM ROWIDS | COUNT)

INDEX (SINGLE VALUE | RANGE SCAN | FULL SCAN)

MERGE

MINUS

OR

AND

KEY ITERATION

Uses bitmapped indexes. AND and KEY ITERATION are new with Oracle9i.

CONCATENATION

Union of multiple sets of data.

CONNECT BY

Uses CONNECT BY clause for hierarchical retrieval.

COUNT

Counts number of rows.

STOPKEY

Count limited by ROWNUM expression in the WHERE clause.

DOMAIN INDEX

Uses domain to retrieve ROWIDs. New with Oracle8i.

FILTER

Eliminates ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required