On 25-06-2011 20:14, Black, Michael (IS) wrote: > So these two queries should be equal in speed and plan: > > > > > > select * from (select min(i) from test) as a,(select max(i) from > test) as b, (select count(i) from test) as c; select > min(i),max(i),count(i) from test;
and, to make the problem simpler, these two statements should be equal in speed too: select * from (select min(i) from test) as a,(select max(i) from test) as b; select min(i),max(i) from test; -- Luuk _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
