On Mon, Mar 9, 2009 at 12:08 AM, Igor Tandetnik <itandet...@mvps.org> wrote:
> > It can't. "hash" column is not part of the index. > Right... I should have seen that. > > Would re-ordering our unique index to be (name, id, value, ...) > > rather than (name, value, id, ...) allow a query with only name and > > id to use it more > > effectively? > > Yes. So would (id, name, ...) Ok, good. I'm not sure we can do this but it's good to know. Thanks again for your help. Cheers, Derek _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users