On Thu, 22 Dec 2011 11:34:41 +0100, Thomas Steinmaurer <[email protected]> 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
