On Sep 5, 2013, at 11:27 PM, Yuzem <naujnit...@gmail.com> wrote: > Any clue on why LEFT JOIN is so slow when used with genres but not with > larger tables?
Sure. But your conclusion is a most likely a red herring. The crux of the matter is that inner and outer join have a wildly different semantic. And therefore execution plan. That's all. Seems all very reasonable from an optimizer point of view. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users