Hash Join Algorithm | Analytics Database 17.20 | Teradata Vantage - Hash Join Algorithm for Semi-Join - Analytics Database - Teradata Vantage

With this feature, queries with correlated EXISTS/NOT EXISTS, or non-correlated IN/NOT IN subqueries (on columnar tables) may have plan changes and performance improvements.

• EXISTS/IN: If the original plan uses inclusion hash join, the new plan may use hash join with post-join SORT (for duplicate elimination).
• NOT EXISTS/NOT IN: If the original plan uses exclusion hash join, the new plan may use left/right hash join with "..IS NULL" post-join term.