Name

EXPLAIN PLAN

Synopsis

EXPLAIN PLAN
   SET STATEMENT_ID = 'text'
[INTO
[schema.]table_name[@dblink]]
   FOR sql_statement

Creates an explanation of the execution plan for a SQL statement.

Keywords

SET STATEMENT_ID

Specifies a text string (`text ') to be used to identify the result of this EXPLAIN PLAN statement. The default is NULL.

INTO

Specifies the location of the PLAN_TABLE (table_name). If you omit schema, the default is a PLAN_TABLE in your own schema. Specify @dblink to indicate a remote database.

FOR sql_statement

Specifies the SQL statement for which the plan is to be generated.

Notes

You must have the 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 will appear in the STATEMENT_ID column of the destination table.

Example

The following example generates an execution plan for the SQL statement listed. The output will be placed in the PLAN_TABLE table in the current schema:

EXPLAIN PLAN
   SET STATEMENT_ID = 'Plan1'
   FOR 
   SELECT ename,sal,comm,loc 
   FROM emp,dept
   WHERE emp.deptno=dept.deptno
..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset