Skip to main content

Use Where Exists

Enable to use WHERE EXISTS type SQL statements instead of LEFT JOIN type statements for lookups in ELT processing.

When to Change This Setting​

This is a SQL-style preference for the generated lookup logic: WHERE EXISTS expresses the existence check directly, while LEFT JOIN with a null filter is the traditional formulation. Which form performs better depends on the target platform's optimizer; keep the default unless the alternative form measurably improves your load plans.

Notes​

  • This setting is part of the Data Vault settings category.
  • The default value for this setting is N.