Expand description
Optimizer rule for rewriting subquery filters to joins
It handles standalone parts of logical conjunction expressions, i.e.
WHERE t1.f IN (SELECT f FROM t2) AND t2.f = 'x'
will be rewritten, but
WHERE t1.f IN (SELECT f FROM t2) OR t2.f = 'x'
won’t
Structs
Optimizer rule for rewriting subquery filters to joins