On 3/7/17, Olivier Mascia <[email protected]> wrote: >> Le 7 mars 2017 à 04:13, Richard Hipp <[email protected]> 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 [email protected] _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
