Tried that but no output. Will check my application code, my guess it doesn't handle this statement well.
RBS On Sat, Aug 26, 2017 at 10:05 PM, Richard Hipp <d...@sqlite.org> wrote: > On 8/26/17, Bart Smissaert <bart.smissa...@gmail.com> wrote: > > Thanks, tried that but no output. > > Should I run: pragma optimize(1) ? > Yes. Except that now that ANALYZE has been run, it wouldn't do > anything. DROP the sqlite_stat1 table, then run the query again, then > run "PRAGMA optimize(1)". > > > -- > 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-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
