Re: Optimization rules for semi and anti joins

>>> I wrote: 
> You've got a name, and you want a list of outstanding warrants for
> parties with a matching name.
Correction, if that was the list you wanted, you would use an inner
join, not a semijoin.  For purposes of this illustration I guess you
would be looking for a list of parties who have outstanding warrants,
not a list of the warrants themselves.
-Kevin