Order By or Dataview sort quickest?

  • Thread starter Thread starter Earl
  • Start date Start date
E

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?
 
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
 
Back
Top