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> |
|
|