Unable to Force to Use Domain Index for a Query with Multiple Contains
(Doc ID 465078.1)
Last updated on OCTOBER 08, 2015
Applies to:Oracle Text - Version 188.8.131.52 to 184.108.40.206 [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.
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!