December 2002
Intermediate to advanced
928 pages
85h 29m
English
EXPLAIN PLAN
EXPLAIN PLAN SET STATEMENT_ID = 'text' [INTO [schema.]table_name[@dblink]] FORSQL_statement
Creates an explanation of the execution plan for a SQL statement.
You must have INSERT privilege on the destination table (specified by INTO) before issuing this command. The destination table is usually called PLAN_TABLE, and can be created by running the script utlxplan.sql. The value specified in the SET clause appears in the STATEMENT_ID column of the destination table
Specifies a text string used to identify the result of this EXPLAIN PLAN statement. The default is NULL.
Specifies the name and location of the plan table. The default is to use a table named PLAN_TABLE in your current schema.
Specifies the SQL statement for which the plan is to be generated.
Common keywords and clauses: dblink, schema, table_name.