Archives of the TeradataForum
Message Posted: Sun, 05 Dec 2004 @ 16:13:08 GMT
<-- Anonymously Posted: Sunday, December 05, 2004 10:48 -->
Is it a standard optimization technique now to use Group by instead of Distinct to optimize queries that need to remove duplicate records?
Is there any difference in results, in case I am going to use group by instead of distinct? If there is no difference why doesn't the optimizer use the duplicate removal operation which is faster in Group by instead of the one that is use in distinct?
Thanks in advance.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 27 Dec 2016|