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 Columns That Do Not Contain an Index

The Case Insensitivity Wizard defines a CIAI column and index only on a column that already includes an index. However, you can run the Case Insensitivity Wizard for a column that does not include an index but that meets all the other eligibility criteria. This mode changes the Default Insensitivity property from None to DB Case & Accent. In a query, Siebel CRM converts column values to uppercase before it performs the comparison. This work allows a search to be case and accent insensitive.

For example, in the S_CONTACT table, assume the LAST_NAME column does not include an index. You run the Case Insensitivity Wizard to set the Default Insensitivity property to DB Case & Accent. If you query for the name Smith, or any case variant such as SMITH or smiTH, then the object manager uses a query similar to the following:

SELECT column list FROM S_CONTACT
WHERE UPPER(LAST_NAME) LIKE UPPER(Smith)

To use the Case Insensitivity Wizard on columns that do not contain an index

1. In Siebel Tools, open the desired repository.

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

2. From the Tools menu, choose Utilities, and then the Case Insensitivity menu item.
3. Choose the Enable for All Unindexed Columns option, and then click Next.

   The Case Insensitivity Wizard does the following:

   • Locates unindexed columns that meet CIAI eligibility criteria
   • Displays a list of tables that you must lock
4. Click Export to export the list of tables to a text file, then exit the Case Insensitivity Wizard.
5. Open the text file in a text editor.
6. In Siebel Tools, lock all tables that are listed in the text file.
7. Start the Case Insensitivity Wizard again, choose the Enable for All Unindexed Columns option, and then click Next.

   The Case Insensitivity Wizard does the following:

   • Locates unindexed columns
   • Displays a list that describes how the unindexed columns are configured
8. Verify that method is Database and Index Strategy is None for all columns.

   If the index strategy is None, then the Case Insensitivity Wizard does not create a CIAI column or index.

9. Click Next.

   The Case Insensitivity Wizard displays a list that describes the Siebel repository changes it will make.

10. Verify that the Default Insensitivity property is DB Case & Accent for all columns.
11. Click Finish.

    The Case Insensitivity Wizard makes the changes to the Siebel repository.