Bookshelf Home | Contents | Index | PDF |
Siebel Database Upgrade Guide > Siebel Case Insensitivity Wizard > Overview of What the Case Insensitivity Wizard DoesEnvironments: Development environment only. Platforms: Windows, UNIX, IBM z/OS. The Case Insensitivity Wizard performs the following functions in the repository to configure columns to support CIAI queries. No columns or indexes are created in the Siebel database until you synchronize the repository to the Siebel database. The columns that you want to configure for CIAI queries are called base columns:
The Case Insensitivity Wizard can also be run in a special mode to set the Default Insensitivity property on columns that do not have any indexes defined. The main purpose of the CIAI query enhancement is to provide indexes that can be used for case insensitive searches. The database does not have to perform table scans to locate records. This enhancement allows the database to perform case insensitive searches more quickly. For example, in S_CONTACT, you configure the column LAST_NAME for CIAI queries. The Case Insensitivity Wizard defines a column called LAST_NAME_CI. When you query for the name Smith, the Object Manager creates a query similar to the following (IBM DB2): SELECT WHERE LAST_NAME_CI indicates SMITH The database then uses the CIAI index on LAST_NAME_CI to locate the records. For columns where Force Case is set, the data in the database is all in the same case. No CIAI columns or indexes are needed. The Object Manager uses the indexes already defined on the base column to retrieve records. Related TopicsRelated Books |
Siebel Database Upgrade Guide | Copyright © 2016, Oracle and/or its affiliates. All rights reserved. Legal Notices. | |