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 Columns That Do Not Contain an IndexThe 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 To use the Case Insensitivity Wizard on columns that do not contain an index
|
Configuring Siebel Business Applications | Copyright © 2016, Oracle and/or its affiliates. All rights reserved. Legal Notices. | |