• Welcome
• Projects
• Presentations
• Research

DDL STATEMENT

Description

DDL statement. Appears in V$SQL_PLAN when EXPLAIN PLAN is executed

Versions

This operation has currently only been observed in Oracle 9.0.1

This operation is implemented in the following versions

Example

This example was developed using Oracle 9.0.1 on Windows 2000

This example requires access to a PLAN_TABLE

This example requires the following table definition

    CREATE TABLE t1 (c1 NUMBER);

    EXPLAIN PLAN FOR SELECT COUNT(*) FROM t1;

The table does not need to be analysed

The statement

    SELECT id, parent_id, operation, options, object_name
    FROM v$sql_plan
    WHERE (address, hash_value, child_number) IN
    (
      SELECT address, hash_value, child_number
      FROM v$sql
      WHERE sql_text LIKE 'EXPLAIN PLAN FOR SELECT COUNT(*) FROM t1'
    )
    ORDER BY id;

generates the following execution plan

0     DDL STATEMENT
1   0   SORT (AGGREGATE)
2   1     TABLE ACCESS (FULL) OF 'T1'