PLAN_TABLE_OUTPUT

 
----------------------------------------------------------------------------------------------------
| Id  | Operation                       | Name                        | Rows  | Bytes | Cost (%CPU)|
----------------------------------------------------------------------------------------------------
|   0 | UPDATE STATEMENT                |                             |   177K|   489M|    10M  (1)|
|   1 |  UPDATE                         | SQ_PRODUCT_DESCRIPTION      |       |       |            |
|*  2 |   FILTER                        |                             |       |       |            |
|   3 |    TABLE ACCESS FULL            | SQ_PRODUCT_DESCRIPTION      |  3551K|  9798M| 16398   (1)|
|   4 |    MERGE JOIN CARTESIAN         |                             |     1 |  2470 |     3   (0)|
|*  5 |     TABLE ACCESS BY INDEX ROWID | IF_NAN_PROD_L               |     1 |  2464 |     1   (0)|
|*  6 |      INDEX RANGE SCAN           | IDX_IF_NAN_PROD_L_PROD_CODE |     1 |       |     1   (0)|
|   7 |     BUFFER SORT                 |                             |     1 |     6 |     2   (0)|
|*  8 |      TABLE ACCESS BY INDEX ROWID| IF_PARAMETERS               |     1 |     6 |     2   (0)|
|*  9 |       INDEX RANGE SCAN          | PK_IF_PARAMETERS            |     1 |       |     1   (0)|
|  10 |   MERGE JOIN CARTESIAN          |                             |     1 |  2470 |     3   (0)|
|* 11 |    TABLE ACCESS BY INDEX ROWID  | IF_NAN_PROD_L               |     1 |  2464 |     1   (0)|
|* 12 |     INDEX RANGE SCAN            | IDX_IF_NAN_PROD_L_PROD_CODE |     1 |       |     1   (0)|
|  13 |    BUFFER SORT                  |                             |     1 |     6 |     2   (0)|
|* 14 |     TABLE ACCESS BY INDEX ROWID | IF_PARAMETERS               |     1 |     6 |     2   (0)|
|* 15 |      INDEX RANGE SCAN           | PK_IF_PARAMETERS            |     1 |       |     1   (0)|
----------------------------------------------------------------------------------------------------
 
Predicate Information (identified by operation id):
---------------------------------------------------
 
   2 - filter( EXISTS (SELECT 0 FROM "IF_PARAMETERS" "IP","IF_NAN_PROD_L" "IFL" WHERE 
              "IFL"."PRODUCT_CODE"=:B1 AND "IFL"."LANGUAGE_CODE"=:B2 AND ("IFL"."SHORT_DESCRIPTION"<>:B3 
              OR "IFL"."LONG_DESCRIPTION"<>:B4) AND "IP"."INTERFACE_ID"='NAN' AND 
              "IP"."COUNTRY_CODE"=:B5))
   5 - filter("IFL"."LANGUAGE_CODE"=:B1 AND ("IFL"."SHORT_DESCRIPTION"<>:B2 OR 
              "IFL"."LONG_DESCRIPTION"<>:B3))
   6 - access("IFL"."PRODUCT_CODE"=:B1)
   8 - filter("IP"."COUNTRY_CODE"=:B1)
   9 - access("IP"."INTERFACE_ID"='NAN')
  11 - filter("IFL"."LANGUAGE_CODE"=:B1)
  12 - access("IFL"."PRODUCT_CODE"=:B1)
  14 - filter("IP"."COUNTRY_CODE"=:B1)
  15 - access("IP"."INTERFACE_ID"='NAN')
 
Note
-----
   - 'PLAN_TABLE' is old version