On 8/26/17, Bart Smissaert <[email protected]> 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 [email protected] _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
