What is the amount of performance improvement you get with doing BULK COLLECT? I tried answering I will measure with the cost.. but the interviewer wants a specific answer. Is there any general formula for deriving the cost improvement based on the no. of records processed in bulk fetch?

Nikhil Inamdar

 Profile Answers by Nikhil Inamdar Questions by Nikhil Inamdar

• Jul 4th, 2016

Generally for millions of records, BULK COLLECT performs very much faster. If we compare BULK COLLECT and normal CURSOR FOR LOOP then BULK COLLECT can perform almost 4 times faster.
You can create your own program and use DBMS_UTILITY.GET_TIME for comparing the results.

dinesh

• Feb 3rd, 2013

We can limit the bulk binding values. It would improve the overall performance. It would not consume more memory.

Answer Question  Select Best Answer