Re: [sqlite] Does Reindex Change Stats Tables?
On 10/24/16, Denis Burke 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
[sqlite] Does Reindex Change Stats Tables?
> 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). ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Does Reindex Change Stats Tables?
On 10/24/16, Denis Burke wrote: > I am wondering if I run reindex than should I always run analyze > afterward? If the reindex command though also updates the stats in > addition to recreating the actual indexes, then of course i would not need > it. > REINDEX does *not* update the stats. You must run ANALYZE separately. May I ask why you are running REINDEX? -- 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
[sqlite] Does Reindex Change Stats Tables?
I am wondering if I run reindex than should I always run analyze afterward? If the reindex command though also updates the stats in addition to recreating the actual indexes, then of course i would not need it. Thanks, Denis ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
