How often should I index new or updated records?

Answer: If you run reindexing with CTX_DDL.SYNC_INDEX less often, your indexes will be less fragmented, and you will not have to optimize them as often.

However, your data becomes progressively more out-of-date, and that may be unacceptable to your users.

Overnight indexing is acceptable for many systems. In this case, data that is less than a day old is not searchable. Other systems use hourly, 10-minute, or 5-minute updates.

See Also:

• Oracle Text Reference to learn more about using CTX_DDL.SYNC_INDEX

• “Managing DML Operations for a CONTEXT Index”