Thanks for the tip, ANALYZE is the cause. Without it the index will be searched.
Staffan On Thu, Jul 17, 2014 at 7:38 PM, Simon Slavin <slav...@bigfraud.org> wrote: > > 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 > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users