Shulou(Shulou.com)06/01 Report--

Http://blog.itpub.net/25834554/viewspace-1054672/

Non-archived, T01 (LOGGING), the redo value generated by ordinary INSERT statements: 1255940

Non-archived, the redo value generated by T01 (LOGGING), HINT / * + append*/,: 2416

Archiving, T01 (LOGGING), the redo value generated by ordinary INSERT statements: 1199344

Archiving, T01 (LOGGING), HINT / * + append*/, generated redo value: 1232780

Archive, T01 (LOGGING), / * + append*/ + nologging, the resulting redo value: 1233040

Archiving, T01 (NOLOGGING), the redo value generated by ordinary INSERT statements: 688

Archiving, T01 (NOLOGGING), HINT / * + append*/, generated redo value: 1199248

Combining the above data, if you want the INSERT statement to execute faster and produce less redo, there are two situations:

1. Non-archiving mode: use HINT / * + append * / in INSERT statements

two。 Archive mode: change the target table to NOLOGGING (alter table xxx nologging), and then use HINT / * + append * / in the INSERT statement.

3. In addition, parallel operations can be taken; drop removes index constraints and so on, and then rebuilds and restores.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.