>>>>> "Guillaume" == Guillaume Smet <guillaume(dot)smet(at)gmail(dot)com> writes:
Guillaume> - "While semi-joins merely replace existing IN joins,
Guillaume> anti-joins are a new capability for NOT IN and NOT EXIST
Guillaume> clauses (Tom) This improves optimization possibilities."
Guillaume> -> remove the "(Tom)", s/EXIST/EXISTS/
Also s/NOT IN and // (anti-joins are not used for NOT IN due to the
awkward semantics of nulls). Should possibly also mention the fact that
some outer joins can be planned as anti-joins too.
--
Andrew (irc:RhodiumToad)