Skip to Main Content
Oracle in a Nutshell
book

Oracle in a Nutshell

by Rick Greenwald, David C. Kreines
December 2002
Intermediate to advanced content levelIntermediate to advanced
928 pages
85h 29m
English
O'Reilly Media, Inc.
Content preview from Oracle in a Nutshell

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

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Oracle Internals

Oracle Internals

Donald K. Burleson
Oracle PL/SQL

Oracle PL/SQL

Lewis Cunningham
Oracle Essentials: Oracle9i, Oracle8i and Oracle8, Second Edition

Oracle Essentials: Oracle9i, Oracle8i and Oracle8, Second Edition

Rick Greenwald, Robert Stackowiak, Jonathan Stern

Publisher Resources

ISBN: 0596003366Errata Page