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
