On Thu, Oct 11, 2012 at 3:13 AM, Hamish Symington < ham...@lightbluesoftware.com> wrote:
> > > If you run ANALYZE on your database, SQLite will have more information > with > > which to estimate the run-time of each plan, and is more likely to choose > > the faster on. At the very least, it much less likely for the estimated > > run-times to tie. Even better is if you compile with SQLITE_ENABLE_STAT3 > > and then run ANALYZE. > ANALYZE run; still the same result. > Please send me your complete schema and the content of the sqlite_stat1 and sqlite_stat3 tables and I will have a look. -- D. Richard Hipp d...@sqlite.org _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users