On 21/01/2012 2:44 PM, Simon Slavin wrote:
On 21 Jan 2012, at 7:23pm, Ryan Johnson wrote:
It's a SQL89 join. Sqlite docs say SQL89 and SQL92 joins perform identically
[1], which I confirmed before sending the OP.
Oh. Okay. If it spits out the same EXPLAIN QUERY PLAN then SQLite is
interpreting it the same way.
Which brings us back to the original question: why does sqlite spit out
a bad query plan when a vastly better one exists? There's no clear
reason the better answer should have been hard to find.
Ryan
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users