Configuring Siebel Business Applications > Improving the Performance of Siebel Business Applications > Using the Case Insensitivity Wizard to Improve Query Performance >

Choosing the Correct Repository when Running the Case Insensitivity Wizard

This topic describes how to choose the correct repository.

To choose the correct repository when running the Case Insensitivity Wizard

  1. If you are not upgrading a development environment, then do the following:
    1. In the development environment, run the Case Insensitivity Wizard on the Siebel Repository.
    2. Generate another schema.ddl file, and then use it to update your test and production environments.
  2. If you are upgrading a development environment, then run the Case Insensitivity wizard on the New Customer Repository.

    Later in the upgrade process, Siebel CRM renames this repository to Siebel Repository. To revise the columns you configured for a case insensitive query, you can run the Case Insensitivity Wizard after an upgrade is complete. For more information, see Siebel Database Upgrade Guide.

Configuring Siebel Business Applications Copyright © 2011, Oracle and/or its affiliates. All rights reserved. Legal Notices.