Rebuild an index

When an index contains errors, you can rebuild it by scheduling a rebuild job.

When you rebuild an index, the index will be dropped from the system, which means that all free text searches that use the index in question will be disabled for WorkZone users.

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.

Important: When scheduling an index rebuild job, make sure the job does not conflict with any other jobs running on the database, for example a scheduled nightly backup job.

 

To schedule a rebuild job on 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 schedule a rebuild job for. You can also double-click the index to open the Setting for... form for the index.
  5. In the Text Indexes form, click Settings for... to open the Settings for... form.
  6. 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.
  7. Click Save to save your changes and schedule the rebuild job.

See also

Set index parameters

Set index parameters

Optimize an index

Drop an index