title: How to sync and optimize an Oracle Text index?
body: <p>We want to use a <code>ctxsys.context</code> index type for full text search. But I was quite surprised, that an index of this type is not automatically updated. We have 3 million documents with about 10k updates/inserts/deletes per day.</p>
  
  <p>What are your recommendations for syncing and optimizing an Oracle Text index?</p>