Table 66. Running the Case Insensitivity Wizard to Accomplish Various CIAI Configuration Tasks
|
How to Run the Case Insensitivity Wizard |
Define new columns to support a CIAI query. |
Use an input file or choose files manually. |
Deactivate CIAI for defined columns. |
Use an input file that specifies the desired columns. For each column, set Operation to Off. |
Change the Default Insensitivity property from None to DB Case & Accent for eligible columns without indexes. |
Choose the Tools menu, Utilities, and then the Case Insensitivity menu item. Choose the Enable for All Unindexed Columns option. |
Change the method from Force Case to Database for columns that are already defined. |
Use an input file or choose files manually. |
Change the method from Database to Force Case for columns that are already defined. |
Use an input file that specifies the desired columns. For each column, set Operation to Off. This technique deactivates the CIAI column and CIAI indexes. Verify that the Force Case property is set for base columns. |
Change the index strategy from Single to Copy All for columns that are already defined. |
Use an input file that specifies to change the index strategy from Single to Copy All. |
Change the index strategy from Copy All to Single for columns that are already defined. |
Do the following:
- Run the Case Insensitivity Wizard, using an input file that specifies the desired columns. For each column, set Operation to Off. This technique deactivates the CIAI column and CIAI indexes.
- Next, run the Case Insensitivity Wizard on the same base columns with method set to Database and Index Strategy set to Single. This technique activates the index on the CIAI columns.
|