Thursday, 25 October 2012

Which is more efficient GROUP BY or DISTINCT to find duplicates? | Teradata Interview Questions

With more duplicates GROUP BY is more efficient, if only a few duplicates exist DISTINCT is more efficient.

No comments: