Topic
No replies
Ajay Kulkarni
Ajay Kulkarni
19 Posts
ACCEPTED ANSWER

Pinned topic Distinct Vs Group By

‏2014-07-07T03:45:17Z |

Hello,

Why is that Performance Gurus emphasize that one should avoid using DISTINCT, instead should GROUP BY.
Visual explain shows the same plan on a large table for both the statements.