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

Reply via email to