On 8/26/17, Bart Smissaert <bart.smissa...@gmail.com> wrote: > OK, thanks, I got it. > What would be a way to show this output? > I created a large table with no indexes, but no output. Then added an index > but no analyse, but no output.
Create two indexes on the table. Then run some query that could potentially use either index. Then when you run "PRAGMA optimize" it will tell you that you should run ANALYZE on that table. -- 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
