Wilfried Mestdagh a écrit :
AM> No, they will probably not all do the same internally: the result
AM> may be the same, but the "virtual machine" that runs the SQL statements
AM> will very probably do different things - this depends on optimisation
AM> and so on. But for most of us it is mainly the result that counts
AM> (and the time it takes for that result)
But what should then be the best one in speed ?
well, in your SQL query, if you don't mind about VehicleID, there's
nothing to care about speed as SQLite will do a full table scan (and
will find its way to get the fastest full table scan :) )
if restricting in the where clause on VehicleID, then you should create
an index on VehicleID.
HTH,
--
Guillaume MAISON - [EMAIL PROTECTED]
83, Cours Victor Hugo
47000 AGEN
Tél : 05 53 87 91 48 - Fax : 05 53 68 73 50
e-mail : [EMAIL PROTECTED] - Web : http://nauteus.com