v.21.7Improvement

Some queries require multi-pass semantic analysis with reusable sets for IN

Some queries require multi-pass semantic analysis. Try reusing built sets for IN in this case. #24874 (Amos Bird).
Introduces reuse of built sets for IN clauses to optimize queries requiring multi-pass semantic analysis.

Why it matters

To improve query performance and efficiency in scenarios where multiple passes of semantic analysis are necessary by reusing previously constructed sets for IN expressions, reducing redundant computations.

How to use it

This feature is applied automatically when the query involves multi-pass semantic analysis with IN clauses; no additional user configuration is required.