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 APRIL 09, 2024

Applies to:

Goal

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?

Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.