Bookshelf Home | Contents | Index | PDF |
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 WizardThe Case Insensitivity Wizard includes the following variables: Method Variable of the Case Insensitivity WizardThe 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 MethodIf 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 MethodThe 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 example, assume the following:
For more information, see Index Strategy Variable of the Case Insensitivity Wizard. Index Strategy Variable of the Case Insensitivity WizardThe index strategy is a variable that determines how the Case Insensitivity Wizard defines indexes for the CIAI column. Table 61 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 ValuesThe 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 VariableThe Case Insensitivity Wizard uses the following default values for the method variable:
Default Values for the Index Strategy VariableThe Case Insensitivity Wizard uses the following defaults for the index strategy variable:
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:
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 VariableIf you do not include the Operation variable, then the Case Insensitivity Wizard sets Operation to On, regardless of the method or index strategy. |
Configuring Siebel Business Applications | Copyright © 2016, Oracle and/or its affiliates. All rights reserved. Legal Notices. | |