Merge range predicates
Applies to ✅ Open Source Edition ✅ Express Edition ✅ Professional Edition ✅ Enterprise Edition
An AND predicate combining range predicates that share the same operands can often be merged into a single BETWEEN predicate predicate comparing the left operand with the two right operands.
Using Settings.transformPatternsMergeRangePredicates, the following transformations can be achieved:
-- With Settings.transformPatternsMergeRangePredicates active, this: SELECT * FROM tab WHERE x >= a AND x <= b; -- ... is transformed into the equivalent expression: SELECT * FROM tab WHERE x BETWEEN a AND b;
Feedback
Do you have any feedback about this page? We'd love to hear it!