We were struggling with improving the performance of a Oracle stored procedure which extensively uses cursors. Yesterday Aditya has done an amazing job in improving the performance of this procedure from ~3 minutes to ~15 seconds. We all exclaimed a WOW! for his job, he added that he achieved this by modifying the cursor with BULK COLLECT clause. Isn't that amazing? By just adding bulk binding in the select clause the performance was improved dramatically.
Loading