On 17 Jul 2014, at 6:34pm, Staffan Tylen <staffan.ty...@gmail.com> wrote:

> I'm unable to understand why T2 isn't using the index. Is it the fact that
> the table T2 only has 2 rows so SQLite has decided that it's quicker with a
> scan?

Does doing an ANALYZE change anything ?

Simon.
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to