v.24.12Performance Improvement
Add Common Expression Extraction for JOIN Optimization
Add option to extract common expressions fromWHEREandONexpressions in order to reduce the number of hash tables used during joins. This makes sense when the JOIN ON condition has common parts inside AND in different OR parts. Can be enabled byoptimize_extract_common_expressions = 1. #71537 (János Benjamin Antal).