Archives of the TeradataForum
Message Posted: Wed, 15 May 2002 @ 18:24:23 GMT
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.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|