> at least for anyone who has worked with > assembly level programming
That are not many then, but thanks and will have a look at the documentation you mentioned. RBS > [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] > ----------------------------------------------------------------------------- > > > ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------