My Oracle Support Banner

Unable to Force to Use Domain Index for a Query with Multiple Contains (Doc ID 465078.1)

Last updated on OCTOBER 31, 2019

Applies to:

Oracle Text - Version to [Release 9.2 to 11.2]
Information in this document applies to any platform.
***Checked for relevance on 17-Dec-2012***


On Oracle Standard Edition (SE) executing below query results in using full table scan instead of using the text index. Same query works well on Oracle Enterprise Edition (EE) as a BITMAP OR is used to join the two contains results. As bitmap indexes are not available on SE I would have hoped for some other join to occur which would still use the text indexes.

SELECT count(*)
FROM fast_select
CONTAINS(search,'protease within bio',00)>0
CONTAINS(search,'protease within blast',10)>0


To view full details, sign in with your My Oracle Support account.

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

In this Document

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