1 Reply Latest reply: Oct 1, 2012 4:09 PM by Barbara Boehmer RSS

    sync on commit reindex question

    doug8294
      Say I have a text index defined like:
         CREATE INDEX CCC_OFFERINGS_TEXT_INDEX ON ccc_offerings ("INDEX_COL")
         INDEXTYPE IS "CTXSYS"."CONTEXT" PARAMETERS ('lexer new_ccc_offerings_lexer datastore 
      new_ccc_offerings_store sync (on commit)');
      /
      If I want to update a row and to make the index update as well, do I have to change index_col to set off the reindex? Or is changing any field value in the row sufficient?

      Thanks,
      Doug