Archives of the TeradataForum

Message Posted: Wed, 15 May 2002 @ 18:24:23 GMT

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

John and Dieter,

Thanks for providing insight into how this function works. Based on what you have provided, wouldn't you always want to choose the primary index of the source table. (assuming you were trying to number rows and not achieve some other result) This would ensure that none of the data would redistribute during the sort operation. Wouldn't choosing any other combination of columns cause the data to redistribute during the sort?

Or is the spool file distributed based on the first column provided so if you had a multi-column primary index, it would not matter.

Jim

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