This discussion is archived
1 Reply Latest reply: Oct 1, 2012 2:09 PM by Barbara Boehmer RSS

sync on commit reindex question

doug8294 Newbie
Currently Being Moderated
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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points