Index Strategy Variable of the Case Insensitivity Wizard

The index strategy is a variable that determines how the Case Insensitivity Wizard defines indexes for the CIAI column.

The following table describes the index strategies you can use with the method variable set to Database. The wizard sets the Default Insensitivity property to DB Case & Accent no matter which index strategy you use.

Index Strategy	Work That the Case Insensitivity Wizard Performs
None	Defines no new CIAI columns or indexes.
Single	Defines a new CIAI column and defines a single CIAI index on it. For every index that includes the base column, the wizard does not create another index that references the CIAI column.
Copy All	Defines a new CIAI column and a CIAI index for the column. For every index that includes the base column, the wizard defines a copy of that index. The copy references the CIAI column instead of the base column.

Index Strategy

Work That the Case Insensitivity Wizard Performs

None

Defines no new CIAI columns or indexes.

Single

Defines a new CIAI column and defines a single CIAI index on it.

For every index that includes the base column, the wizard does not create another index that references the CIAI column.

Copy All

Defines a new CIAI column and a CIAI index for the column.

For every index that includes the base column, the wizard defines a copy of that index. The copy references the CIAI column instead of the base column.