TIP #37: Update massive number of records.

In order to update large number of records in table, it is better off to follow below steps.
  • create table new_table as select from old_table?
  • index new_table
  • grant on new table
  • constraints on new table
  • drop old_table
  • rename new_table to old_table.

During table creation, nologging and parallel query can be used. This way also generate less redo and no undo.

No comments: