5 Replies Latest reply: Apr 17, 2012 7:06 AM by Roger Ford-Oracle RSS

    wish to alter index not to use stop words

    571794
      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