Bookshelf Home | Contents | Index | PDF |
Siebel Database Upgrade Guide > Upgrading the Siebel Database > Identifying and Dropping Obsolete Indexes for a Siebel UpgradeEnvironments: Production test environment only. Does not apply to production environment. Use this topic to identify indexes that might 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, they do the following to identify obsolete indexes:
You must manually review the gen_obs_idx.sql file. If it contains indexes you want to remove (those containing a drop statement not followed by a create statement), then you must copy the corresponding SQL statements to another SQL file called obs_idx.sql. This file is executed by the Database Server Configuration Utilities in upgrep mode. When the Upgrade Wizard is then run, 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. Requirements: 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
|
Siebel Database Upgrade Guide | Copyright © 2013, Oracle and/or its affiliates. All rights reserved. Legal Notices. | |