EXPLAIN PLAN CLPPlus command

The EXPLAIN PLAN CLPPlus command retrieves explain plan information for any single SQL statement.

Invocation

You must run this command from the CLPPlus interface.

Authorization

None

Required connection

You must be connected to a database.

Syntax diagram

Read syntax diagramSkip visual syntax diagramEXPLAINPLANFORSQL-statement

Command parameters

SQL-statement
The SQL statement on which explain information is retrieved.

Examples

SQL> explain plan for select * from emp where bonus > 1000 and salary>10000;

    ID TYPE            OBJECT_SCHEMA        OBJECT_NAME         PREDICATE_TEXT         
------ --------------- -------------------- ------------------- -----------------------
     1 RETURN                                                                          
     2 TBSCAN          MANSHANB             EMPLOYEE            (10000 < Q1.SALARY)    
     2 TBSCAN          MANSHANB             EMPLOYEE            (1000 < Q1.BONUS)