SELECT STATEMENT Optimizer=ALL_ROWS (Cost=7442)
 PX COORDINATOR
  PX SEND* (QC (ORDER)) OF :TQ10005 (Cost=7442 Cardinality=18 Bytes=3942)
   SORT* (ORDER BY) (Cost=7442 Cardinality=18 Bytes=3942)
    PX RECEIVE* (Cost=7441 Cardinality=18 Bytes=3942)
     PX SEND* (RANGE) OF :TQ10004 (Cost=7441 Cardinality=18 Bytes=3942)
      BUFFER* (SORT) (Cardinality=18 Bytes=3942)
       NESTED LOOPS* (Cost=7441 Cardinality=18 Bytes=3942)
        NESTED LOOPS* (Cost=7441 Cardinality=18 Bytes=3510)
         HASH JOIN* (Cost=7276 Cardinality=1695 Bytes=288150)
          BUFFER* (SORT)
           PX RECEIVE* (Cost=2802 Cardinality=2788 Bytes=206312)
            PX SEND* (HASH) OF :TQ10001 (Cost=2802 Cardinality=2788 Bytes=206312)
             TABLE ACCESS (FULL) OF PLANT_LOGISTICS_ASSIGNMENT (TABLE) (Cost=2802 Cardinality=2788 Bytes=206312)
          PX RECEIVE* (Cost=4473 Cardinality=581323 Bytes=55807008)
           PX SEND* (HASH) OF :TQ10003 (Cost=4473 Cardinality=581323 Bytes=55807008)
            HASH JOIN* (Cost=4473 Cardinality=581323 Bytes=55807008)
             PX RECEIVE* (Cost=2 Cardinality=1022 Bytes=43946)
              PX SEND* (HASH) OF :TQ10002 (Cost=2 Cardinality=1022 Bytes=43946)
               PX BLOCK* (ITERATOR) (Cost=2 Cardinality=1022 Bytes=43946)
                TABLE ACCESS* (FULL) OF MRP_REC (TABLE) (Cost=2 Cardinality=1022 Bytes=43946)
             BUFFER* (SORT)
              PX RECEIVE* (Cost=4470 Cardinality=955599 Bytes=50646747)
               PX SEND* (HASH) OF :TQ10000 (Cost=4470 Cardinality=955599 Bytes=50646747)
                TABLE ACCESS (FULL) OF ORDER_REC (TABLE) (Cost=4470 Cardinality=955599 Bytes=50646747)
         TABLE ACCESS* (BY INDEX ROWID) OF ORDER_REC_DELIVERY_SCHEDULE (TABLE) (Cost=3 Cardinality=1 Bytes=25)
          INDEX* (RANGE SCAN) OF ORDER_REC_DELIVERY_SCHEDULE (INDEX (UNIQUE)) (Cost=2 Cardinality=1)
        TABLE ACCESS* (BY INDEX ROWID) OF CONT_REC (TABLE) (Cost=1 Cardinality=1 Bytes=24)
         INDEX* (UNIQUE SCAN) OF SYS_C005597 (INDEX (UNIQUE)) (Cost=0 Cardinality=1)