> On Mar 6, 2017, at 1:30 PM, Richard Hipp <[email protected]> wrote:
>
> Have you ever wondered when you should run ANALYZE on an SQLite
> database? It is tricky to figure out when that is appropriate. The
> new "PRAGMA optimize" command tries to automate the decision for you.
Very nice!! Thanks for implementing this.
I noticed one typo in the docs of this pragma:
_For_ achieve the best long-term query performance…
Should be something like
_To_ achieve the best long-term query performance…
—Jens
_______________________________________________
sqlite-users mailing list
[email protected]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users