Tag : distinct - SentryOne Team Blog

Tag: distinct

Performance Surprises and Assumptions : GROUP BY vs. DISTINCT

Performance Surprises and Assumptions : GROUP BY vs. DISTINCT

Aaron Bertrand acknowledges that DISTINCT and GROUP BY are usually interchangeable, but shows there are cases where one performs better than the other.