5 Replies Latest reply on Apr 17, 2012 12:06 PM by Roger Ford-Oracle

    wish to alter index not to use stop words

      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