Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 17 Sep 2003 @ 14:22:21 GMT


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


Subj:   Re: How to create sys generated keys
 
From:   Anomy Anom

<-- Anonymously Posted: Wednesday, September 17, 2003 10:16 -->

I don't think so. Isn't the max function applied one time through the table (fast enough with Teradata's Parallel processing with the work distributed across amps) and then used for the rest of the query. This would be much faster much faster than row x row.



     
  <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