On Oct 8, 2011, at 4:42 PM, Mohit Sindhwani wrote: > all will usually have an index on zid and (zid,...) for other queries.
Also such compound indices (zid,...) are pointless as they already have maximum selectivity incorporating the primary key. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users