Thanks, tried that but no output. Should I run: pragma optimize(1) ? RBS
On Sat, Aug 26, 2017 at 9:54 PM, Richard Hipp <[email protected]> wrote: > On 8/26/17, Bart Smissaert <[email protected]> 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 > [email protected] > _______________________________________________ > sqlite-users mailing list > [email protected] > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
