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

[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

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*

[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