NOT IN vs. NOT EXISTS vs. LEFT JOIN / IS NULL: SQL Server | EXPLAIN EXTENDED

How to create fast database queries ... As we can see, this query uses Merge Anti Semi Join which is extremely efficient if there is a cheap way to obtain two ordered resultsets (like in example above).

explainextended.com