On 6 Jan 2011, at 10:46pm, Richard Hipp wrote: > On Thu, Jan 6, 2011 at 5:31 PM, Nicolas Williams < > [email protected]> wrote: > >> it'd be nice to have stable, parseable >> EXPLAIN QUERY PLAN output. > > Enhanced for version 3.7.4. See http://www.sqlite.org/eqp.html for details.
The new output as described on that page is very nice. Would it be possible to extend the 'USE TEMP B-TREE FOR ...' and 'COMPOUND SUBQUERIES ... USING TEMP B-TREE' lines so that the end of the line lists an index that would mean the TEMP B-TREE was not needed ? For example it could produce something like USE TEMP B-TREE FOR GROUP BY (a, b DESC, c) Of course this won't describe the best suggestion for an index in every case, but it may help. Simon. _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
