gp_enable_multiphase_agg
Enables or disables the use of two or three-stage parallel aggregation plans legacy query optimizer (planner). This approach applies to any subquery with aggregation. If gp_enable_multiphase_agg is off, then gp_enable_agg_distinct and gp_enable_agg_distinct_pruning are disabled.
Value Range | Default | Set Classifications |
---|---|---|
Boolean | on | master session reload |