Performance improvement in Bulk Collect

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?

Questions by Jamuna_J

Showing Answers 1 - 6 of 6 Answers

dinesh

  • Feb 3rd, 2013
 

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

  Was this answer useful?  Yes

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.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions