Page History
...
| 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 paralleleparallel, etc. |
| 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. |
...
The "1/24" expression represents one twentyfourth of a day (one hour). The expression uses Oracle's job scheduling syntax.
| Note | ||
|---|---|---|
| ||
When using this synchronization method, the database user needs to have the CREATE JOB system privilege. |
Changing index synchronization to on commit
...
Overview
Content Tools