Exclusion join is a product, merge, or hash join where only the rows that do not satisfy (are NOT IN) any condition specified in the request are joined.
In other words, exclusion join finds rows in the first table that do not have a matching row in the second table.
Exclusion join is an implicit form of the outer join. Geospatial column terms are not permitted for outer join conditions.
Exclusion product joins with dynamic row partition elimination are not supported for PPI tables that have 8‑byte partitioning.
The following SQL specifications frequently cause the Optimizer to select an exclusion join:
To avoid returning join rows that are null on the join column, use one of the following methods:
WHERE Customer.CustAddress IS NOT NULL