Order By or Dataview sort quickest?

[Earl]

Anyone know which operation is faster, an Order By clause in the Select
statement against an SQLCE db, or using the dataview.Sort method?

 

[Darren Shaffer]

if you already have an index that matches the order you are
trying to achieve, the ORDER BY will definitely be
faster if the query processor can use that index (remember,
SQL CE only uses one index per plan).

you can't really answer the general question because the
cardinality of the tables and indexing you've done affect
performance a great deal.

-Darren

 

[Earl]

Thanks Darren. I did not know that SQLCE "only uses one index per plan".