Re: Does VACUUM imply REINDEX?
Simon Slavin <[email protected]> Wed, 19 Feb 2020 16:26:26 +0000
| Newsgroups | gmane.comp.db.sqlite.general |
|---|---|
| Message-ID | <[email protected]> |
On 19 Feb 2020, at 4:18pm, Richard Hipp <[email protected]> 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 [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users