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. Nico -- _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
