On 8/24/18, David Raymond <david.raym...@tomtom.com> wrote: > Running just "explain some query" will give you the virtual machine program > that it plans on using. You can then scan through that to see what it's > doing. Note that the descriptions on the below page for those op codes are > sometimes really confusing and it can take a while to decypher what's going > on. > > https://www.sqlite.org/opcode.html
To further confuse matters, the https://www.sqlite.org/opcode.html page only describes the opcodes for the latest release (3.24.0) whereas the OP is using an earlier release (3.20, I think). Opcodes and their meanings can change from one release to the next. -- 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