On 8/24/18, David Raymond <[email protected]> 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 [email protected] _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
