3 Replies Latest reply on Aug 31, 2012 4:38 PM by Roger Ford-Oracle

    Slow performance with "order by" and "contains"

      We are having a performance issue with "order by" and "contains". If I remove the "order by" from the query, the query returns less than 1 second, but the query takes 10 seconds with "order by". The number of rows returned is only around 100.

      Any suggestion would be greatly appreciated.