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. Aaron Bertrand ◆ January 26, 2017 15