gp_enable_groupext_distinct_pruning
Enables or disables three-phase aggregation and join to compute distinct-qualified aggregates on grouping extension queries. Usually, enabling this parameter generates a cheaper query plan that the legacy query optimizer (planner) will use in preference to existing plan.
Value Range | Default | Set Classifications |
---|---|---|
Boolean | on | master session reload |