On Thu, Aug 21, 2014 at 2:15 PM, Mario M. Westphal <[email protected]> wrote:
>
> When I understand you correctly, I should/must run an ANALYSIS on existing
> databases
>
SQLite will get the correct answer regardless. But you might get the
answer *faster* if you run ANALYZE after significant changes to the
database. But you should always get an equivalent answer.
Additional discussion can be found at:
http://www.sqlite.org/optoverview.html
http://www.sqlite.org/queryplanner-ng.html
--
D. Richard Hipp
[email protected]
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
