Page History
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 | ||
---|---|---|
| ||
Note | ||
| ||
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 | ||
---|---|---|
| ||
Note | ||
| ||
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
...