Updating millions of rows bulk collect Emmanuelle s sensual pleasures 2015 online
Stupid I know but currently the only thing that we can do.In your example, you are not using any content of table "dc_item_loc" to update table "item_loc".Best regards, Iudith As always " Ask Tom" is a great resource.... Also, he ALWAYS recommends rebuilding a table if you have to update a large number of rows.Easy to find-- Google "bulk update in oracle". p=1:0:: :: P11_QUESTION_ID:2367352052686" id="ctl00_m_m_i_ctl00_gr_ctl07_bestanswerbody" class="textarea-bestanswerhidden" name="bestanswerbody" answerbody Id="4676708" / If you're going to go down the road of using a cursor, then looking at a bulk collect and update for all construct might be the way to go... Best Regards, Iudith" id="ctl00_m_m_i_ctl00_gr_ctl09_bestanswerbody" class="textarea-bestanswerhidden" name="bestanswerbody" answerbody Id="4677218" / Hello All, If you read Asktom thoroughly, you will discover that he ALWAYS, but ALWAYS recommends to perform in a single SQL everything that can be done in a single SQL and use PL/SQL only when necessary, and if yes, then NEVER commit inside of the loop.I have tried merging & updating but the performance isn't improving.So now trying with the commit so if I somehow have to close the connection, the updated records can be removed from the first table and it then has to update less.I have used simple update with commit after each statement. UPDATE is the heaviest DML operation and it will take a long time, regardless of whether you COMMIT after each update operation (for one table) or at end only. As an alternative, you can create the new table as an empty table and then use INSERT /* APPEND */ SELECT ...', '