Explain plan table output

posted Jan 13, 2011, 9:30 AM by Sachchida Ojha
 SQL>explain plan for select distinct itransaction_id
from cat.torder_request
where iorder_status = :1 and itransaction_id is not null  2    3  ;

Explained.

ARBINET@stgtdb1  SQL>select PLAN_TABLE_OUTPUT from TABLE (DBMS_XPLAN.DISPLAY());

PLAN_TABLE_OUTPUT
--------------------------------------------------------------------------------
Plan hash value: 4025559849

--------------------------------------------------------------------------------
-----

| Id  | Operation          | Name           | Rows  | Bytes | Cost (%CPU)| Time
    |

--------------------------------------------------------------------------------
-----


PLAN_TABLE_OUTPUT
--------------------------------------------------------------------------------
|   0 | SELECT STATEMENT   |                |  8300 | 74700 | 12988   (3)| 00:02
:36 |

|   1 |  HASH UNIQUE       |                |  8300 | 74700 | 12988   (3)| 00:02
:36 |

|*  2 |   TABLE ACCESS FULL| TORDER_REQUEST |   825K|  7252K| 12915   (2)| 00:02
:35 |

--------------------------------------------------------------------------------
-----

PLAN_TABLE_OUTPUT
--------------------------------------------------------------------------------


Predicate Information (identified by operation id):
---------------------------------------------------

   2 - filter("IORDER_STATUS"=TO_NUMBER(:1) AND "ITRANSACTION_ID" IS NOT
              NULL)

15 rows selected.

ARBINET@stgtdb1  SQL>

Comments