How Do Stop Words in the Oracle Database Affect a Search That Is Done in Content Server with Oracle Text Search?
Last updated on DECEMBER 15, 2017
Applies to:Oracle WebCenter Content - Version 10.1.3.3.1 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