v.25.8Performance Improvement

Execute non-correlated EXISTS as a scalar subquery

Official CH changelog text
Execute non-correlated EXISTS as a scalar subquery. This allows using a scalar subquery cache and constant-folding the result, which is helpful for indexes. For compatibility, the new setting execute_exists_as_scalar_subquery=1 is added. #85481 (Nikolai Kochetov).
PreviousNext