KnowledgeHub
Questions
Tags
Users
Search
Alex Rivera
|
Logout
Edit Question
Title
Body
I know in simple queries the performance and execution plans of the Distinct and Group By are almost the same. e.g. SELECT Name FROM NamesTable GROUP BY Name SELECT DISTINCT Name FROM NamesTable But I've read in some scenarios their performance would be different e.g. in subqueries, etc? So, could you make some examples or explain some scenarios where their performance are different? Many thanks
Tags (comma-separated)
Save Edits
Cancel