Optimize an index

To ensure continued maintenance and efficiency of a free text index, you can schedule regular optimization of the index.

Index optimization is run as a scheduled job on the database and you can define when the index optimization is to start by setting the day, time, and duration of the job.

Note: The default duration for index optimization is 120 minutes. Adjust the job duration for each index to conform to the observed performance of the index optimization. Sometimes you will need to assign more time for the optimization job because the index increases in size due to everyday usage.

You must enable optimization of each specific index. You can also choose not to optimize certain indexes or reduce the frequency of optimization as required by your organization's needs.

Important: When setting the duration of the optimization job, make sure the job does not conflict with any other jobs running on the database, for example a scheduled nightly backup job.

If the optimization job is interrupted and cannot complete the optimization task, it will continue from where it was stopped when the optimization job is started again.

Improving optimization speed

You can select the number of CPU threads allocated to the index optimization job in the Parallel field. By allocating multiple CPU threads to index optimization, you can reduce the time used to optimize the index.

To set up Index optimization

  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 > Text Indexes to open the Text Indexes form.
  3. In the Indexes field group, select the index that you want to schedule optimization for.
  4. 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.
  5. In the Settings for... form, > Optimize group:
    • Select the Use optimize check box to enable optimization for the index.
    • In the Day at time, duration in minutes grid, select which days and time to schedule the optimization and set the duration of the optimization job in minutes.
  6. Click Save to save your changes and schedule optimization of the index.

See also:

Set index parameters

Create or recreate an index

Rebuild an index

Drop an index