v.24.1Improvement

Disable max_rows_in_set_to_optimize_join by Default

Disable max_rows_in_set_to_optimize_join by default. #56396 (vdimir).
The max_rows_in_set_to_optimize_join setting is now disabled by default in ClickHouse.

Why it matters

This change improves default behavior by preventing automatic optimization of joins based on the max_rows_in_set_to_optimize_join threshold, which can lead to better stability and predictability in query execution.

How to use it

Users do not need to take any action to disable this feature, as it is now disabled by default. To re-enable it, users can set max_rows_in_set_to_optimize_join to a positive integer value in their session or server configuration.