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

    Using NOT Gives Performance Issues

    amin_adatia

      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