Unable to Force to Use Domain Index for a Query with Multiple Contains
Last updated on OCTOBER 08, 2015
Applies to:Oracle Text - Version 18.104.22.168 to 22.214.171.124 [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
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