Archives of the TeradataForum

Message Posted: Thu, 27 Mar 2008 @ 20:40:44 GMT

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

Hi Ravikumar,

Group by is less costly if you have multiple distinct values with lots of records for each value.

Distinct is less costly if the number or rows per distinct value are quite low or even unique.

Cheers

Joerg

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