Archives of the TeradataForum
Message Posted: Wed, 13 Sep 2006 @ 16:12:37 GMT
Is selecting data using the distinct clause faster than using a group by clause?
Consider these queries as examples
Select c3, c4 from temp1 Group by 1, 2 Select distinct c3, c4 from temp1
Also (c3, c4) are not PI.
Thanks & Regards,
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|