This discussion is archived
0 Replies Latest reply: Jul 10, 2013 7:02 AM by amin_adatia RSS

Using NOT Gives Performance Issues

amin_adatia Newbie
Currently Being Moderated

I have a query which uses the following syntax


WHERE CONTAINS(a,'((   ((term1 OR terms2) INPATH(/A))  NOT ( ((term3 OR term4) INPATH(/A/B/C)) )') > 0


Using the syntax below works

WHERE CONTAINS(a,'((term1 OR term2) INPATH(/A))) > 0

AND NOT CONTAINS (a,' ((term3 OR term4) INPATH(/A/B/C)) )') > 0



On one Exadata (X2) machine this works just fine. On X3, however, the query goes to never land.Without the NOT portion the query comes back with results.


Anything I can look into the Oracle Text environment?




  • Correct Answers - 10 points
  • Helpful Answers - 5 points