Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Fri, 26 Apr 2002 @ 14:27:10 GMT


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


Subj:   Re: Converting 4-digit dates to standard date
 
From:   John Balchunas

Successfully populated a new table converting 5 full dates thru an Insert/Select and CASE on each date. 52 million rows took just about three hours during the workday on an old 4-node 4700 without any apparent degradation of performance.

Thanks all for your help and to Mike Larkins for his class on optimizing CASE at Midwest TUG on April 23rd in Dayton.

John Balchunas
Jefferson County Public Schools



     
  <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: 27 Dec 2016