Changing Synchronization Mode

Previous

Next

You can change the synchronization mode for a Text index or partition on an index. This is useful for controlling when synchronization will occur if you do not want to manually perform this operation.

To change the synchronization mode:

1. From the Text Indexes page, select the index.

   • If this is a partitioned index, then the Partitions page appears for this index where you must select one or more partitions to edit.

2. Click Edit.

3. On the Edit Text Index page, select the Synchronization Mode tab.

4. Select one of the following modes:

   • Manual. Useful for synchronizing only when you know changes to the base table for the index need to be committed.

   • On Commit. Useful for synchronizing everytime a DML change occurs. However, this setting has significant performance impact.

   • Automatic. Useful for setting a new schedule for a synchronization job.

5. Optionally allocate memory for synchronization. If left empty, then the indexing memory size specified during CREATE INDEX will be used.

6. Click Apply.

You can view the comparable SQL statements for this operation by clicking Show SQL. You can revert back to the previous settings by clicking Revert.