The INCLUDE_STOPWORDS parameter

If you specify the index parameter STOPWORD_LIST when you create an etx index, the words in the list are excluded from the index and are ignored in the clue when you execute subsequent text searches. This behavior is wanted for most searches. Occasionally, however, you might want to execute searches in which stopwords are relevant. For example, you might want to search for the exact phrase to be or not to be and do not want the stopwords to be excluded.

To force the stopwords specified by the STOPWORD_LIST parameter to be indexed, specify INCLUDE_STOPWORDS='TRUE' when you create the etx index.

In this case, stopwords are indexed, similar to the default behavior, but they are considered part of the clue only if the tuning parameter CONSIDER_STOPWORDS is specified in the etx_contains() operator. If you do not specify CONSIDER_STOPWORDS during a search, the stopwords are ignored.

Important: The CONSIDER_STOPWORDS tuning parameter of the etx_contains() operator works only if you specified INCLUDE_STOPWORDS when you created the etx index.

The index parameter INCLUDE_STOPWORDS must always be used together with STOPWORD_LIST. The only way the DataBlade® module can recognize stopwords is by consulting the stopword list associated with the index, specified through the STOPWORD_LIST index parameter. If you specify INCLUDE_STOPWORDS alone, the parameter is ignored.