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