title: Oracle 12c full text index maintainence
body: <p>We are planning to use a context index for full text search in Oracle 12c standard edition. </p>
  
  <p>The data on which search will run is a JSON containing one Channel post and its replies from a 3rd party tool that is loaded into our database.(basically, all the chats and replies(including other attributes like timestamp/user etc) are stored in this table).</p>
  
  <p>We are expecting about 50k rows of data per year and a daily of 100-150 DMLs per day. Our index is "SYNC ON COMMIT" currently,so what are the recommendations for optimizing the Oracle Text index? </p>