On 10/24/16, Denis Burke <burke...@gmail.com> 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