Hi, community Here I recommend a new rule for converting UNION ALL sub plan to a single input with an OR filter, the following is its conversion diagram. [image: UnionAllToOrRule.jpg]
The conversion prerequisites are 1. left filter range has no intersection with right filter range. 2. Project and Input Sub Tree must be identical. The rule will be used when Input Sub Tree is a computing-intensive or large IO operation. I don't know whether the community supports it or not, any suggestions will be appreciated.
