On 19 Feb 2020, at 4:18pm, Richard Hipp <d...@sqlite.org> wrote: > There is no benefit to running > ANALYZE after running VACUUM if the ANALYZE data (the content of the > sqlite_stat1 table) is still up-to-date.
However, if you have a yearly maintenance procedure, it might make sense to include ANALYZE in it. This would take care of circumstances where your business has changed character, for instance changing from selling a lot to a few customers, to selling a little to many customers. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
