>>>>> "Guillaume" == Guillaume Smet <guillaume.smet@gmail.com> writes:
Guillaume> - "While semi-joins merely replace existing IN joins,Guillaume> anti-joins are a new capability for NOT IN
andNOT EXISTGuillaume> 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)