use_index_for_in_with_subqueries_* session settings

These settings are available in system.settings and are autogenerated from source.

use_index_for_in_with_subqueries

Try using an index if there is a subquery or a table expression on the right side of the IN operator.

use_index_for_in_with_subqueries_max_values

The maximum size of the set in the right-hand side of the IN operator to use table index for filtering. It allows to avoid performance degradation and higher memory usage due to the preparation of additional data structures for large queries. Zero means no limit.