Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

issue in long running procedure

3150994Jan 8 2016 — edited Jan 12 2016

hi ,

issue in long running procedure

i have procedure which is taking long time for inserting the records , we are inserting the records by using For all bulk load process , i heard that if we disable index before loading the data then loading will be fast but as i am using the cursor ,so is it possible to drop the index before loading the data , please suggest me what is the good approach

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 9 2016
Added on Jan 8 2016
29 comments
4,866 views