On Mon, Jun 20, 2011 at 6:55 AM, Ryan Johnson <ryanj...@ece.cmu.edu> wrote:
> IIRC sqlite does *not* do any join ordering optimizations and simply > runs them in whatever order the query specifies. This can have > unfortunate effects on runtime for some queries. Can anyone verify this? > > The SQLite query optimizer started reordering joins beginning with SQLite version 3.2.3 in August 2005. -- D. Richard Hipp d...@sqlite.org _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
