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

If you run the Case Insensitivity Wizard to configure a large number of columns for a CIAI query, or if you must use a nondefault method or index strategy, then you can use an input file. The wizard reads the input file, and then configures the columns in the file. Using an input file allows you to control which configuration options the Case Insensitivity Wizard uses. Oracle provides recommended input files. For more information, see Input File You Can Use with the Case Insensitivity Wizard.

To use the Case Insensitivity Wizard on a table

1. In Siebel Tools, open the repository.

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

2. Lock the tables that are listed in the input file.
3. From the Tools menu, choose Utilities, and then Case Insensitivity.
4. Choose Administer the Columns Listed in This File, and then click Browse.

   Siebel Tools displays the tools\objects directory, which contains the default csv input files.

5. Choose the desired csv file, click Open, and then click Next.

   The Case Insensitivity Wizard validates the following:

   • Format of the input file
   • Eligibility of all tables and columns

     If the file contains an error, then the wizard lists the records that contain the errors. If you continue, then the wizard skips records that contain errors. If there are errors, then click Export to export the error list to a text file, correct the errors, and then restart the Case Insensitivity Wizard.

     For more information, see Input File You Can Use with the Case Insensitivity Wizard.

6. Click Next.

   The Case Insensitivity Wizard displays the records in the input file.

7. Review the configuration settings and verify they are correct.

   If you must change any configuration settings, do the following:

   1. Click Export.

      The Case Insensitivity Wizard exports the list to a text file.

   2. Edit the text file, and then restart the Case Insensitivity Wizard, specifying the edited text file as the input file.
8. Click Next.

   The Case Insensitivity Wizard displays the changes it will make to repository tables and indexes.

9. (Optional) If you must save a record of the changes, then click Export.

   The Case Insensitivity Wizard writes the changes to a text file.

10. Click Finish.

    The Case Insensitivity Wizard configures the columns in the Siebel repository to support a CIAI query.

11. In the Tables list, click Apply/DDL.
12. Compile your changes.

Input File You Can Use with the Case Insensitivity Wizard

The Case Insensitivity Wizard can accept a comma-delimited (.csv) file as input. Each line in the file is one record that defines one column that the wizard configures for a CIAI query. Oracle provides a recommended input file. The input files include a csv file extension and are located in the objects subdirectory of your Siebel Tools installation. These files list columns that Siebel CRM frequently uses for queries. You can edit these files or create new input files.

You must use the following format for each record:

TABLE_NAME,COLUMN_NAME,Method,Index Strategy,Operation

where:

TABLE_NAME and COLUMN_NAME are required.

For example:

S_CONTACT,EMAIL_ADDR,Database,Copy All,On

The Case Insensitivity Wizard inserts the default value for any optional variable that you omit.

If you omit a variable from a record, then you must provide a delimiting comma that represents the placeholder for the variable. In the following example, the Index Strategy variable is omitted:

S_CONTACT,EMAIL_ADDR,Database,,On

The Case Insensitivity Wizard does not perform special handling for a denormalized column. To configure a CIAI query on denormalized columns, you must include them in an input file.

For more information, see Variables You Can Use with the Case Insensitivity Wizard.