0 Replies Latest reply on Jul 10, 2013 2:02 PM by amin_adatia

    Using NOT Gives Performance Issues


      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?