Rebuild an index
When an index contains errors, you can rebuild it by scheduling a rebuild job.
Rebuilding an index can be a time- and space consuming process for the database and server, and should be scheduled to run in periods where the entire system is not used extensively, for example at night or during the weekend. The actual time required to rebuild an index will vary with the size of the database, server resources, and other factors. You should therefore only rebuild an index if it is necessary to do so - for example if the index has failed for some reason. Additionally, you must enable index rebuilding for each index by selecting the Use rebuild check box.
Scheduling the rebuild job
The rebuild job can be scheduled and you must set the date and time for when the job will start. You can also schedule rebuild jobs at fixed intervals.
Schedule a rebuild job on 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 schedule a rebuild job for. You can also double-click the index to open the Setting for... form for the index.
- In the Text Indexes form, click Settings for... to open the Settings for... form.
- In the Settings for... form, > Rebuild group:
- Select the Use rebuild check box to enable index rebuilding.
- In the Next day field, set the date and time for when the index rebuild job is to start.
- In the Weeks between rebuild field, set the frequency of the rebuild job, which is measured as the number of weeks between the rebuild jobs.
- Click Save to save your changes and schedule the rebuild job.
