Hi, If I have an index on table1(colA, colB), will it be used for both the where and the order by in either of these cases:
select * from table1 where colA=1 order by colB; select * from table1 where colB=1 order by colA; -- ˙uʍop-ǝpısdn sı ɹoʇıuoɯ ɹnoʎ 'sıɥʇ pɐǝɹ uɐɔ noʎ ɟı _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
