Bump?
On 21/01/2012 2:47 PM, Ryan Johnson wrote:
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
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users