Reducing the physical reads
First Run
Statistics
----------------------------------------------------------
205 recursive calls
0 db block gets
182998 consistent gets
79000 physical reads
0 redo size
0 workarea executions - onepass
0 workarea executions - multipass
0 parse time cpu
0 parse count (failures)
19 execute count
2 rows processed
Elapsed: 00:08:59:61
Second Run
Statistics
----------------------------------------------------------
0 recursive calls
0 db block gets
182942 consistent gets
11 physical reads
0 redo size
0 workarea executions - onepass
0 workarea executions - multipass
0 parse time cpu
0 parse count (failures)
2 execute count
2 rows processed
Elapsed: 00:00:07:21
Thanks