Kirill M?ller wrote: > I see no reason why the following two queries can't be executed with the same > plans: > > ... t1 LEFT JOIN t2 ... > ... t1 LEFT JOIN (SELECT * FROM t2) ...
In this case, the queries are identical. But SQLite's query optimizer does not try to optimize this because such trivial subqueries are (thought to be) unlikely to occur in practice. Regards, Clemens
