Performance - Upgrade

It is utmost important to write efficient code in upgrade scripts so that they can run significantly fast over large volume of data. It is expected to have millions of record in some table and bad query may extend the upgrade days.

This section recommend you some of the best practices to be followed when writing upgrade scripts.

Contents

• Avoid cursor loops
• Avoid unnecessary update when adding null column
• DML on Multiple Records
• Load Controlling for Rollback Segments