On 11/30/2010 11:38 PM, Duquette, William H (316H) wrote: > I've just discovered EXPLAIN QUERY PLAN; it looks quite useful, but one part > of the output is somewhat opaque. > > The command returns three columns: order, from, and detail. "order" is > evidently the order in which the indices are applied; the "detail" explains > which table and index is involved. But what does the "from" column mean? > > Thanks!
The output of EQP is changing for 3.7.4. But the interpretation of the "from" column remains the same. See here: http://www.sqlite.org/draft/eqp.html Buried about 2/3 of the way through section 1.1. _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
