On 3/7/17, Olivier Mascia <o...@integral.be> wrote: >> Le 7 mars 2017 à 04:13, Richard Hipp <d...@sqlite.org> a écrit : >> >> the database connection remembers (in RAM) specifically which >> tables and indexes it has considered for use and will only run ANALYZE >> on those tables for which some prior query would have benefited from >> having good sqlite_stat1 numbers during the current session. > > What if or what impact is there from this pragma optimize when the software > has been built with SQLITE_ENABLE_STAT4?
Then the ANALYZE commands that are run will also build the sqlite_stat4 table. But STAT4 data is not a factor in determining when ANALYZE is run. -- D. Richard Hipp d...@sqlite.org _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users