Page History
...
UI Text Box | ||
---|---|---|
| ||
Please note that each index synchronization increases the index fragmentation, degrading search performance over time. Consult the [Editor] How to maintain full-text search performance article to learn more about index fragmentation and how to maintain the full-text index. |
Changing index synchronization to manual
To change the index synchronization to manual execute the following script:
...
When changing the full-text index to manual synchronization, any modification to aggregates and documents will not be reflected in the index until the stored procedure CTX_DDL.SYNC_INDEX is not manually called. This has to be done by DBA either manually, or through a scheduled job.
Changing index synchronization interval
To change the index synchronization to a regular interval, execute the following script:
...
UI Text Box | ||
---|---|---|
| ||
When using this synchronization method, the database user needs to have the CREATE JOB system privilege. |
Changing index synchronization to on commit
To change the index synchronization behaviour so that the index is synchronized after every commit, execute the following script:
...