UPDATE
1, the first backup data (security, improve performance).
2, batch update, small batch submission, to prevent the lock table.
3, if the updated automatically indexed, the amount of updated data is very large, the first to cancel the index, and then recreate.
4, the whole table data update, if the table is very large, it is recommended to create a new table in the form of alternative updates.
DELETE
1, batch submission, reduce the time to lock the table, reduce the Roll back section pressure.
2. Mass data deletion plus rownum<1000.
3, mass deletion, no middle-ctrl + +, or kill tune session.
4, a large number of data deleted after the best reconstruction index, analysis table.
INSERT
1. Close Redo log (ALTER TABLE <TABLENAME> nologging;)
2, use/*+ append * * hint.
3, binding variables.
4, Batch submission.
5, if the table is static, exclusive use, you can remove the index and other related constraints.
6, a large number of pouring data to analyze the table.
7. Use SQL load to load data quickly.
