Siebel Database Upgrade Guide > Siebel Database Upgrade Planning >

About the Siebel Case Insensitivity Wizard

Environments: Development environment only.

Platforms: Windows, UNIX, IBM z/OS.

Databases: All databases.

As of Siebel CRM 8.0, query features were enhanced to provide indexes that directly support case and accent insensitive (CIAI) queries on eligible text columns. The Siebel Case Insensitivity Wizard configures specified columns for CIAI queries by defining CIAI columns and CIAI indexes in the repository. The wizard also sets the Default Insensitivity property for these columns to DB Case & Accent.

The purpose of the enhanced CIAI features is to improve query effectiveness and performance. Running the Case Insensitivity Wizard is optional.

NOTE:  Before performing an upgrade or incremental repository merge, you must drop any CIAI indexes and CIAI columns. Run the Case Insensitivity Wizard again after completing the upgrade or incremental repository merge.

Related Topics

Siebel Case Insensitivity Wizard

Related Books

Configuring Siebel Business Applications