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 <[email protected]> wrote: > > On 17 Jul 2014, at 6:34pm, Staffan Tylen <[email protected]> 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 > [email protected] > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
