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.