Drop an index

If an index contains too many errors or is recreated or built incorrectly, you can drop the index from use, which removes it from the database. This enables you to recreate the index.

If an index is dropped, all free text searches that use the index in question will be disabled for WorkZone users.

To drop an index

1. On the WorkZone Content Server, press Start and type ScanSQL to open the ScanSQL form. You can also press ALT+R in windows to open the Run window and type ScanSQL.
2. In the ScanSQL form, click SjBase to open the SjBase form.
3. In the SjBase form, click Text Indexes to open the Text Indexes form.
4. In the Indexes field group, select the index you want to drop.
5. In the Text Indexes form, click Settings for... to open the Settings for... form. You can also double-click the index to open the Setting for... form for the index.
6. In the Settings for... form, > Index group, click Drop index to drop the index.

See also

Set index parameters

Create or recreate an index

Optimize an index

Rebuild an index