[EMAIL PROTECTED] wrote:
Is there any documentation about how to analyze the results of EXPLAIN?
Or even better is there a utility that could analyze (at least to some
extent) the results for you?
The documentation you need is in the VDBE tutorial at
http://www.sqlite.org/vdbe.html and the opcode reference at
http://www.sqlite.org/opcode.html
The only utility is the explain command in the sqlite shell. Use
.explain on to get a nicely formatted display and then execute
explain <SQL statement>;
Its really fairly simple (at least for anyone who has worked with
assembly level programming) to follow the execution of an SQL statement
by the virtual machine (at least for simple statements). Following the
logic of a complex statements can be challenging because there are no
human friendly text labels for branches, table and index names, or
runtime variables.
HTH
Dennis Cote
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
