On 10/24/16, Denis Burke <burke...@gmail.com> wrote: >> REINDEX does *not* update the stats. You must run ANALYZE separately. > >> May I ask why you are running REINDEX? > > Sure. We issue new releases of our application about every 3 months. With > some of these, we update the schema of the underlying DB. And with some of > these schema updates, we have changed the collation sequence (typically > added or removed collation).
REINDEX is only needed if you change the implementation of a collation without changing its name. REINDEX was created to allow indexes to be rebuilt on phones when the customer changed the collating methods for hanzi or kanji. -- 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