set advanced_aggregation enables and disables advanced aggregation at the session level.
set advanced_aggregation on/off
For more information, see “Eager and Lazy Aggregation.”