v.23.1Performance Improvement
Always Use IN for LowCardinality Columns Instead of OR Chain
Always replace OR chainexpr = x1 OR ... OR expr = xNtoexpr IN (x1, ..., xN)in the case whereexpris aLowCardinalitycolumn. Settingoptimize_min_equality_disjunction_chain_lengthis ignored in this case. #42889 (Guo Wangyang).