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