On 12/6/19, Keith Medcalf <kmedc...@dessus.com> wrote: > > Perhaps the optimizer could make a "left join" that is not actually an outer > join into a "cross join" and preserve the nesting order ... ? >
It could do that, but that would kind of defeat the whole purpose of the optimization, which was to free up the planner to choose a different nesting order in cases where the LEFT JOIN didn't really matter. I suspect that ANALYZE might also solve the OP's problem. -- D. Richard Hipp d...@sqlite.org _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users