Home Page for the TeradataForum
 
https:

Archives of the TeradataForum

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


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


Subj:   Re: Sequential number generation
 
From:   Jim Downey

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>>  
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 28 Jun 2020