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

Using the Case Insensitivity Wizard on a Table Column

To run the Case Insensitivity Wizard, you can manually choose a table column. The wizard uses configuration defaults to configure the column. To modify the configuration options, you can export the configuration strings to a text file, edit them, and then use the edited file as an input file to run the wizard.

To use the Case Insensitivity Wizard on a table column

  1. In Siebel Tools, open the desired repository.

    For more information, see Choosing the Correct Repository when Running the Case Insensitivity Wizard.

  2. In the Object Explorer, click Table.

    As an alternative, you can display the Object Explorer in Flat mode, click Column, and then locate the desired column in the Columns list.

  3. In the Tables list, choose the table you must modify.
  4. In the Object Explorer, expand the Table tree, and then click Column.
  5. In the Columns list, right-click the column you must modify, and then choose Case Insensitivity.

    The Case Insensitivity Wizard does the following:

    • Validates the eligibility of the chosen column
    • Lists any column that contains an eligibility error in the Configure Case Insensitivity dialog box.

      If there is an error, then you can export the error list to a text file, correct the error, and then restart the Case Insensitivity Wizard. To export the error list, click Export. If there is an error and you continue, then the Case Insensitivity Wizard skips any column that contains an error.

      TIP:   To run the Case Insensitivity Wizard for multiple columns, hold down the CTRL key while you choose each column in the Columns list.

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