This discussion is archived
3 Replies Latest reply: Aug 31, 2012 9:38 AM by Roger Ford RSS

Slow performance with "order by" and "contains"

932383 Newbie
Currently Being Moderated
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

Legend

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