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

Variables You Can Use with the Case Insensitivity Wizard

The Case Insensitivity Wizard includes the following variables:

• Table
• Column
• Method
• Index Strategy
• Operation

Method Variable of the Case Insensitivity Wizard

The method variable of the Case Insensitivity Wizard determines how the wizard configures a CIAI query for a column. This topic describes the methods that are available.

About the Force Case Method

If you set the method to Force Case, then the Case Insensitivity Wizard does not create a CIAI column or index. You can use the Force Case method for a column where the Force Case property of a table column is already set.

If the Force Case property is FirstUpper, Lower, or Upper, then Siebel CRM forces the column data to the case that is set in the Force Case property before it writes data to the Siebel database. All data in the base column is in the same case. The object manager can use the base column and the base column indexes for a query that is not case-sensitive. A CIAI column and CIAI indexes are not required. To get records, the object manager uses the indexes that Siebel CRM already defines on the base column.

If Force Case is FirstUpper, LOWER, or Upper, then the Case Insensitivity Wizard considers Force Case to be set for a column. If Force Case is empty, then the wizard does not consider Force Case to be set.

About the Database Method

The Database method defines a CIAI column for the base column. It uses the index strategy variable to create indexes. The Case Insensitivity Wizard does the following work for indexes that contain multiple columns as keys:

• For the first key where the column becomes CIAI enabled, the wizard defines a copy of the index. In the copy, the key references the CIAI column instead of the base column.
• For each additional key that is CIAI enabled, the wizard deletes the index copy in the Siebel repository and redefines it so keys reference the additional CIAI columns.

For example, assume the following:

1. The S_CONTACT table contains Base Column A. This column includes Index A, which uses the LAST_NAME and FST_NAME columns as keys.
2. You choose the LAST_NAME column for a CIAI query and define the Copy All index strategy.
3. The Case Insensitivity Wizard defines the LAST_NAME_CI column and a CIAI index for the new column.
4. To create Index B for Base Column A, the wizard copies Index A and specifies LAST_NAME_CI and FST_NAME as keys.
5. You choose the FST_NAME column for a CIAI query.
6. As part of configuring FST_NAME for a CIAI query, the wizard does the following work in the Siebel repository:
   • Defines a new FST_NAME_CI column.
   • Deletes Index B on Base Column A and redefines it with the LAST_NAME_CI and FST_NAME_CI keys.

For more information, see Index Strategy Variable of the Case Insensitivity Wizard.

Index Strategy Variable of the Case Insensitivity Wizard

The index strategy is a variable that determines how the Case Insensitivity Wizard defines indexes for the CIAI column.

Table 68 describes the index strategies you can use with the method variable set to Database. The wizard sets the Default Insensitivity property to DB Case & Accent no matter which index strategy you use.

How the Case Insensitivity Wizard Uses Default Values

The Table Name and Column Name are the only required variables for the Case Insensitivity Wizard. If you omit the other variables, then the Case Insensitivity Wizard uses the defaults that this topic describes.

Default Values for the Method Variable

The Case Insensitivity Wizard uses the following default values for the method variable:

• If the Force Case property is set on the table column, then the wizard uses the Force Case method.
• If the Force Case property is not set on the table column, then the wizard uses the Database method.

Default Values for the Index Strategy Variable

The Case Insensitivity Wizard uses the following defaults for the index strategy variable:

• If the method is Force Case, then the wizard sets the index strategy to None.
• If the method is Database, and if the base column does not contain an index, then the wizard sets the index strategy to None.
• If the method is Database, and if the base column contains an index, then the wizard uses the Copy All index strategy.

If the Case Insensitivity Wizard uses None as an index strategy, then the wizard does not define new columns or indexes. It sets the Default Insensitivity property to DB Case & Accent.

The Case Insensitivity Wizard runs the following default logic:

• If the Force Case property is set on a column, then the wizard does not define columns or indexes.
• If the column contains an index, then the wizard does not define columns or indexes.

In these situations, the Case Insensitivity Wizard accepts the column as eligible but does not define columns or indexes. These default behaviors define implicit eligibility requirements.

Default Values for the Operation Variable

If you do not include the Operation variable, then the Case Insensitivity Wizard sets Operation to On, regardless of the method or index strategy.