Hi there, thank you in advance. I have a problem concerns with performance. However, i believe that the program has been good enough for performance as it follows good using BULK COLLECT and FORALL techniques. The DBA sees that updating about 700 thousand records takes about 46 minutes and he suggested me to commit per 70 thousand records. My question is: is it correct that the more commit will make it faster? (May be because of the more resources available for the next 70 thousand?)
best regards, ib