What is the rationale about placing complex conditions in the ON part of an inner join rather than in an WHERE clause?
I understand that the ON clause will limit the temporary table processed by a subsequent WHERE clause, while a larger table will be filtered by the WHERE part if no selective ON clause is present. But with a complex condition (20+ sub-conditions on various part of joined tables) requiring full tables scan, aren't both solutions essentially equivalent? _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users