About Tuning the Upgrade Scripts

Upgrades: All upgrades.

Environments: Production test environment only. Does not apply to production environment.

You can tune the SQL upgrade scripts in a production test environment to improve their performance and then reuse these tested scripts in the live production environment. For example, the scripts used to upgrade your Siebel database are generic. They update your Siebel database to support all Siebel applications’ functionality. You can reduce downtime by tuning these scripts to optimize performance by eliminating SQL statements that are not required. You can then reuse these revised scripts in your production upgrade.

You can tune your production upgrade scripts at any time after upgrading the Siebel database schema in your production test environment.