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 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
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
|This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.|