I'm pretty sure he literally meant `ANALYZE`. From https://sqlite.org/lang_analyze.html : > The ANALYZE command gathers statistics about tables and indices and stores the collected information in internal tables of the database where the query optimizer can access the information and use it to help make better query planning choices. `sqlite_analyzer` only tells you how bloated your database is, while `ANALYZE` actually works to improve performance.