[Monotone-devel] Re: [sqlite] bad index selection?

[Derek Scherger]

On Mon, Mar 9, 2009 at 12:08 AM, Igor Tandetnik <address@hidden> 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