Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Fri, 11 Apr 2003 @ 19:50:44 GMT


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


Subj:   Re: How to implement the sequence concept in Teradata
 
From:   Dieter N�th

Ganga Palakattil wrote:

  For example, if you need to keep a log table (process log), it is a good idea to generate an automatic sequence number to identify the process. Latest run of the process will have the maximum value for the Sequence Number.  



Be aware that this is not true in Teradata. From SQL Manual Vol. 4:

"Because the Teradata architecture is highly parallel, generated identity column numbers do not necessarily reflect the chronological order in which rows are inserted."


Dieter



     
  <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: 15 Jun 2023