Using eager aggregation

Eager aggregation is an internal query processing feature. You need not change anything at the SQL level when you enable eager aggregation; queries that use aggregation have eager aggregation-based plans automatically enumerated and costed by the optimizer.