On 6/3/15, Brian Green <briangreenery at gmail.com> wrote: > one of the queries my application uses joins > two subqueries together, and the use of an automatic index can create a > dramatic difference in the query performance. SQLite does choose to create > an automatic index if I run 'analyze', however running 'analyze' can take a > few minutes on
You can run "ANALYZE sqlite_master" to create the sqlite3_stat1 table, then populate it with fake values using "INSERT INTO sqlite_stat1 VALUES(...);". Harvest the fake values by doing a real "ANALYZE" on a representative database in the lab, then insert those values into each new database you create. -- D. Richard Hipp drh at sqlite.org
