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
- 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.
- In the ScanSQL form, click SjBase > Text Indexes to open the Text Indexes form.
- In the Indexes field group, select the index you want to drop.
- 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.
- In the Settings for... form, > Index group, click Drop index to drop the index.
