On 20/06/2011 6:59 AM, Richard Hipp wrote: > 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. Oh, good. Searching the docs, I found where I was led astray: http://www.sqlite.org/vdbe.html (granted, the page does say it's many years out of date, but I forgot where I'd read it).
Ryan _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users