GROUP BY and DISTINCT
For cases when the GROUP BY is semantically equivalent to DISTINCT, the optimizer makes a cost‑based decision to eliminate duplicates either by way of a combined sort and duplicate elimination or an aggregation step.
For cases when the GROUP BY is semantically equivalent to DISTINCT, the optimizer makes a cost‑based decision to eliminate duplicates either by way of a combined sort and duplicate elimination or an aggregation step.