|Subject||Re: order-by problem|
> hmmm, if i understood right what helen said in an earlier post thenI am curious about Helen's post, because from my experience, select
> select and count is faster then "select first x"
First X is reasonably efficient, providing
a) You do not order the data
b) The order by clause can use an index
If you order by a non-indexed field, then of course the entire table
will need to be read.