On Thu, Jan 6, 2011 at 5:31 PM, Nicolas Williams < [email protected]> wrote:
> On Thu, Jan 06, 2011 at 12:44:51PM +0000, Simon Slavin wrote: > > This is a very big advantage for users who don't really understand how > > SQL works. And it's the sort of thing professional programmers hate, > > because it cheapens the effort they put into learning database theory > > and design. > > Agreed. It'd be better to have tools that help users optimize their DBs > for their queries. Constructing such tools is not exactly easy. But it > should be feasible to build a tool that takes a DB and a SELECT > statement and outputs a set of sets of CREATE INDEX statements that > would result in possibly better query plans -- the user would still have > to evaluate which query plan (and therefore which set of additional > indexes) is best. For that 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. > > Nico > -- > _______________________________________________ > sqlite-users mailing list > [email protected] > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- D. Richard Hipp [email protected] _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
