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 > Using the Case Insensitivity Wizard on a TableIf 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 the configuration options that 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
Input File You Can Use with the Case Insensitivity WizardThe 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 You must use the following format for each record:
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. |
Configuring Siebel Business Applications | Copyright © 2016, Oracle and/or its affiliates. All rights reserved. Legal Notices. | |