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.
RBS On Sat, Aug 26, 2017 at 9:16 PM, Clemens Ladisch <clem...@ladisch.de> wrote: > Bart Smissaert wrote: > > Looking at the results of sqlite3_column_count (1) and also > > sqlite3_column_name (optimize) it > > seems that pragma optimize can have an output. What would that output be > > and what would be a way to show such ouput? > > <http://www.sqlite.org/pragma.html#pragma_optimize> says: > | The optional MASK argument is a bitmask of optimizations to perform: > | > | 1. Debugging mode. Do not actually perform any optimizations but > | instead return one line of text for each optimization that would > | have been done. Off by default. > > > Regards, > Clemens > _______________________________________________ > 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
