v.25.10Performance Improvement
Provides a logic regarding pushing down the disjunction JOIN predicates
Provides a logic regarding pushing down the disjunction JOIN predicates. Example: in TPC-H Q7 for a condition on 2 tables n1 and n2 like(n1.n_name = 'FRANCE' AND n2.n_name = 'GERMANY') OR (n1.n_name = 'GERMANY' AND n2.n_name = 'FRANCE')we extract separate partial filters for each tablen1.n_name = 'FRANCE' OR n1.n_name = 'GERMANY'for n1 andn2.n_name = 'GERMANY' OR n2.n_name = 'FRANCE'for n2. #84735 (Yarik Briukhovetskyi).