Class AggregateFilterTransposeRule

All Implemented Interfaces:

@Enclosing public class AggregateFilterTransposeRule extends RelRule<AggregateFilterTransposeRule.Config> implements TransformationRule
Planner rule that matches an Aggregate on a Filter and transposes them, pushing the aggregate below the filter.

In some cases, it is necessary to split the aggregate.

This rule does not directly improve performance. The aggregate will have to process more rows, to produce aggregated rows that will be thrown away. The rule might be beneficial if the predicate is very expensive to evaluate. The main use of the rule is to match a query that has a filter under an aggregate to an existing aggregate table.

See Also: