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 a 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 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 click 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 an error occurs, 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 no error occurs and you continue, then the Case Insensitivity Wizard skips any column that contains an error.

     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.