How to process Large volume data with good performance
Hi,
I have a cursor which returns around 800000 records/run. Below is the sample code i'm writing to process the cursor data
Declare
Cursor c1 is select column_1.....Column110
from <table_name >
where conditions1 = condition2.
type sample_tbl_typ is table of c1%rowtype index by simple_integer;
sample_tbl sample_tbl_typ;
type sample_tbl_typ1 is table of <table_rowtyp>%rowtype index by simple_integer; --this table is having near about 110 columns
sample_tbl1 sample_tbl_typ1;
begin
open c1;
fetch c1 bulk collect into sample_tbl;
close c1;
if sample_tbl.count > 0 then
for i in sample_tbl.first..sample_tbl.last loop