SQL> select M1.REQUEST ,M1.STATUS ,M1.ACTION_ID ,M1.PRIORITY ,
  2  TO_CHAR(M1.ACTION_DATE,'YYYYMMDDHH24MISS') ,
  3  M1.GMD_MARKET_ID ,
  4  M1.SCCODE,M1.PLCODE ,M1.SWITCH_ID ,M1.CO_ID ,M1.DATA_1 ,
  5  M1.DATA_2 ,M1.DATA_3 
  6  from MDSRRTAB M1 where WORKER_PID=0 order by M1.REQUEST;
truncating (as requested) before column PLCODE

Execution Plan
----------------------------------------------------------
   0      SELECT STATEMENT Optimizer=CHOOSE (Cost=1685 Card=79 Bytes=3
   1    0   SORT (ORDER BY) (Cost=1685 Card=79 Bytes=3160)
   2    1     TABLE ACCESS (FULL) OF 'MDSRRTAB' (Cost=1670 Card=79 Byt




Statistics
----------------------------------------------------------
          0  recursive calls
         17  db block gets
      17354  consistent gets
      16113  physical reads
          0  redo size
      13656  bytes sent via SQL*Net to client
       1088  bytes received via SQL*Net from client
         11  SQL*Net roundtrips to/from client
          1  sorts (memory)
          0  sorts (disk)
        137  rows processed
        
        
        
select M1.REQUEST ,M1.STATUS ,M1.ACTION_ID ,M1.CO_ID ,
M1.CUSTOMER_ID ,GM.CLEAN_UP_LEVEL ,GA.ACTION_DES 
from MDSRRTAB M1 ,GMD_MPDSCTAB GM ,GMD_ACTION GA 
where ((M1.WORKER_PID=0 and GM.SCCODE = M1.SCCODE) and GA.ACTION_ID=M1.ACTION_ID) 
order by REQUEST;



134 rows selected.


Execution Plan
----------------------------------------------------------
   0      SELECT STATEMENT Optimizer=CHOOSE (Cost=1689 Card=79 Bytes=4
   1    0   SORT (ORDER BY) (Cost=1689 Card=79 Bytes=4424)
   2    1     HASH JOIN (Cost=1674 Card=79 Bytes=4424)
   3    2       HASH JOIN (Cost=1672 Card=79 Bytes=2212)
   4    3         TABLE ACCESS (FULL) OF 'MDSRRTAB' (Cost=1670 Card=79
   5    3         TABLE ACCESS (FULL) OF 'GMD_MPDSCTAB' (Cost=1 Card=8
   6    2       TABLE ACCESS (FULL) OF 'GMD_ACTION' (Cost=1 Card=40 By




Statistics
----------------------------------------------------------
         62  recursive calls
         41  db block gets
      17400  consistent gets
      16181  physical reads
          0  redo size
      10415  bytes sent via SQL*Net to client
       1007  bytes received via SQL*Net from client
         10  SQL*Net roundtrips to/from client
          4  sorts (memory)
          0  sorts (disk)
        134  rows processed



select M1.REQUEST ,M1.STATUS ,M1.VMD_RETRY ,M1.ERROR_RETRY ,
M1.SWITCH_ID ,M1.CO_ID ,M1.CUSTOMER_ID ,GA.ACTION_ID ,
GA.ACTION_DES,GM.BYPASS_IND 
from MDSRRTAB M1 ,GMD_ACTION GA ,GMD_MPDSCTAB GM
where ((M1.WORKER_PID=0 and M1.ACTION_ID=GA.ACTION_ID)
and M1.SCCODE=GM.SCCODE) 
order by M1.REQUEST;


142 rows selected.


Execution Plan
----------------------------------------------------------
   0      SELECT STATEMENT Optimizer=CHOOSE (Cost=1689 Card=79 Bytes=4
   1    0   SORT (ORDER BY) (Cost=1689 Card=79 Bytes=4819)
   2    1     HASH JOIN (Cost=1674 Card=79 Bytes=4819)
   3    2       HASH JOIN (Cost=1672 Card=79 Bytes=2607)
   4    3         TABLE ACCESS (FULL) OF 'MDSRRTAB' (Cost=1670 Card=79
   5    3         TABLE ACCESS (FULL) OF 'GMD_MPDSCTAB' (Cost=1 Card=8
   6    2       TABLE ACCESS (FULL) OF 'GMD_ACTION' (Cost=1 Card=40 By




Statistics
----------------------------------------------------------
         62  recursive calls
         41  db block gets
      17400  consistent gets
      12913  physical reads
          0  redo size
      12339  bytes sent via SQL*Net to client
       1088  bytes received via SQL*Net from client
         11  SQL*Net roundtrips to/from client
          4  sorts (memory)
          0  sorts (disk)
        142  rows processed