Archives of the TeradataForum

Message Posted: Sun, 05 Dec 2004 @ 16:13:08 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

<-- 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.

	<Prev	Next>		<<First	<Prev	Next>	Last>>