Archives of the TeradataForum
Message Posted: Mon, 20 Jun 2011 @ 15:00:24 GMT
<-- Anonymously Posted: Monday, June 20, 2011 10:40 -->
What is the differences between Distinct vs. group by from TD 13 onwards.
Internally Distinct will be written as below.
Rewrite Distinct to Group By Select Distinct Col From Table rewritten as Select Col from Table Group By Col
Are they one and the same performance wise.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|