Posted by David Portas on 10/11/05 17:14

If you don't need the result ordered then definitely drop the ORDER BY.

Why do you want to return 17,000 rows in one hit anyway? Can't you
process the data server side?

--
David Portas
SQL Server MVP
--

• Next in forum: Re: Any way to optimise this query?
• Prev in forum: Any way to optimise this query?
• Thread view: Re: Any way to optimise this query?

[Reply to this message]