Hi all,
We have an issue with BULK COLLECT INTO arrays.
When i put some dummy statements, Initial BULK COLLECTS are very fast and when the process moves i.e. loop goes forward, the BULK COLLECT IS BECOMING SLOW.
Actually, how did i came to a conclusion is, the cursors which are being used in bulk collect is fetching data within no time.
In specific, if i run the query which is part of cursor, the records are returned in 0.01 seconds.
So In BULK COLLECT I am using the LIMIT as 100 (read some, process some and again repeat the process).
The main table in the query contains 20 million records.
Could some one please help me out what would be the issue.
Apologies if the information does not suffice to answer my question.
Regards,
Karthik