Skip to main content
These settings are available in system.settings and are autogenerated from source.

​
correlated_subqueries_default_join_kind

Controls the kind of joins in the decorrelated query plan. The default value is right, which means that decorrelated plan will contain RIGHT JOINs with subquery input on the right side. Possible values:
  • left - Decorrelation process will produce LEFT JOINs and input table will appear on the left side.
  • right - Decorrelation process will produce RIGHT JOINs and input table will appear on the right side.

​
correlated_subqueries_substitute_equivalent_expressions

Use filter expressions to inference equivalent expressions and substitute them instead of creating a CROSS JOIN.

​
correlated_subqueries_use_in_memory_buffer

Use in-memory buffer for correlated subquery input to avoid its repeated evaluation.
Last modified on July 23, 2026