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

Reply via email to