On Thu, 22 Dec 2011 11:34:41 +0100, Thomas Steinmaurer
<ts@...> wrote:

>> select First 200 skip 0 .... from MyTable where c = XY and d = zw and A
>> > x and b< Z ... ORDERBY C, D
>>
>> what is the best :
>
> Take an eye on the execution plan, I/O stats in the monitoring table or
> via the trace api.
>
> Btw, you know that with the usage of FIRST above, you probably won't get

> your expected result?
>
> You probably want to do:
>
> select first 200 skip 0 ... from (
> select ... from order by c, d
> )

Are you sure? I would assume the ordering would be applied first, and only
then would the first clause be applied.

Mark