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. 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 modifies the Default Insensitivity property from None to DB Case & Accent. In a query, Siebel CRM converts column values to uppercase before it does 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 a repository.

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

2. Click the Tools menu, click Utilities, and then click 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 the text file lists.
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 modifications 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 modifications to the Siebel repository.