How Do Stop Words in the Oracle Database Affect a Search That Is Done in Content Server with Oracle Text Search?

(Doc ID 876691.1)

Last updated on DECEMBER 15, 2017

Applies to:

Oracle WebCenter Content - Version and later
Information in this document applies to any platform.


How do stopwords in the Oracle database affect a search that is done in Content Server with Oracle Text Search?

If a search is done with a stopword like "here" as the value for one field, and Public as the security group, you get all Public items back in the results. This makes sense since stopwords are thrown out of the query.

However, if you search just for the stopword in the one field with no other criteria set, you get no results back at all instead of all items returned.

Why is this?


Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms