Performance difference between Group By V/S Distinct

former_member575448 — Mon, 06 Apr 2020 15:09:18 GMT

Could you please let me know is there difference between Group by V/S Distinct from performance point of view ?

Re: Performance difference between Group By V/S Distinct

former_member575448 — Mon, 06 Apr 2020 15:14:15 GMT

1. GROUP BY and DISTINCT both generate the same query execution plan when no aggregates are used.

2. GROUP BY becomes important when aggregates are used. DISTINCT is just for filtering out duplicate records from query result sets.

Based on my understanding, GROUP BY is good during complex scenario compared to DISTINCT.