Thanks, now it works! I get: optimize ----------- ANALYZE "main"."t1"
RBS On Sun, Aug 27, 2017 at 12:48 AM, Richard Hipp <d...@sqlite.org> wrote: > On 8/26/17, Bart Smissaert <bart.smissa...@gmail.com> wrote: > > I looked at my application code and that seems OK, but the output is a > > single null value. > > What kind of output should I get? > > The following script shows you what to expect: > > CREATE TABLE t1(a INTEGER PRIMARY KEY,b,c); > CREATE INDEX t1b ON t1(b); > CREATE INDEX t1c ON t1(c); > SELECT a FROM t1 WHERE b=5 AND c=9; > PRAGMA optimize(-1); > > Looks like the argument to optimize should be -1, not 1, in order to > see the debugging output. > > -- > 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 > _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
