This discussion is archived
5 Replies Latest reply: Apr 17, 2012 5:06 AM by Roger Ford RSS

wish to alter index not to use stop words

571794 Newbie
Currently Being Moderated
So when we implemented the oracle text search, the text index got the default stop list (for english language). Obviously, the stop words are not considered when user does a text search. But now we wish to remove the stop list and let the user search for text having stop words. for e.g. "phone by android", here "by" is stop word.

So i can alter all the index now as by passing CTX_DDL.REMOVE_STOPWORD so that the stop list is not used.

Nowthe query - HAving done that, should i rebuild all the index so that the stop words are indexed as well and treated like any other tokens while searching? OR just altering the index not to use the stop list will serve my purpose.

Comments/inputs are welcome

Legend

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