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

{code}

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

{code}

 

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?

 

Regards

Legend

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