On Tue, Apr 30, 2013 at 11:59 AM, Richard Hipp <d...@sqlite.org> wrote: > http://www.sqlite.org/draft/queryplanner-ng.html
That's quite interesting. Should the user have a way to influence the query planner? Perhaps by indicating a cost for each table source? SQL is supposed to let the RDBMS pick the best query plan, but the RDBMS can't always pick the best plan... in such cases users like to have a way to dictate the plan. And/or the RDBMS could keep state about different plans tried in the past and learn to pick better plans, but this sounds very complicated. Nico -- _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
