NOT IN clauses can be converted to more efficient anti-joins when NULL values are not present.
NOT IN
NULL