3 Replies Latest reply: Aug 31, 2012 11:38 AM by Roger Ford-Oracle RSS

    Slow performance with "order by" and "contains"

    932383
      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.

      Thanks.

      Jun