Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

In OracleText, a full-text index can be configured to synchronize manually, at regular intervals or on commit. By default, the Blueriq full-text index on aggregates and documents is synchronized every hour. To change this behaviour, the index needs to be rebuilt with different parameters. 

UI Text Box
typenote
Note
titleNote

Always consult the documentation of your particular Oracle database version. The following examples illustrate how to change the synchronization behaviour without setting additional options such as whether the index is rebuilt online or offline, whether it is rebuilt in parallel, etc.

UI Text Box
typenote
Note
titleNote

Please note that each index synchronization increases the index fragmentation, degrading search performance over time. Consult the TODO: article link article to learn more about index fragmentation and how to maintain the full-text index.

...

Changing index synchronization to manual

...