On 10/24/16, Denis Burke <[email protected]> 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 [email protected] _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
