Bookshelf Home | Contents | Index | PDF |
Upgrade Guide > Upgrading the Siebel Database > Identifying and Dropping Obsolete Indexes for a Siebel UpgradeUpgrades: All Siebel upgrades. Environments: Production test environment only. Does not apply to production environment. This topic is part of an upgrade process. See How to Perform a Siebel Database Upgrade. Use this topic to identify indexes that may be obsolete in the Siebel Database and can be dropped. This topic is optional but is recommended since dropping obsolete indexes improves database performance. When you run the Database Server Configuration Utilities in Prepare for Production mode, it does the following to identify obsolete indexes:
This file is not executed when you run the Upgrade Wizard. You must manually review the file. If it contains indexes you want to drop, you must copy the corresponding SQL statements to another SQL file. This file is executed by the Upgrade Wizard after you run the Database Server Configuration Utilities in upgrep mode. When the Upgrade Wizard runs, all indexes, including obsolete indexes, are maintained during table rebuilds and data migration. The obsolete indexes file is executed during the Create Siebel Indexes step. Prerequisites: You must have run the Database Server Configuration Utilities in Prepare for Production mode in the production test environment. To identify and drop obsolete indexes
|
Upgrade Guide | Copyright © 2006, Oracle. All rights reserved. | |