Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 14 Oct 2009 @ 12:01:34 GMT


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


Subj:   Re: Integer data types vs. Decimal(n,0) - which is better?
 
From:   Boris Mogilevsky

Dieter, thanks for the explanation, though the last part is not very clear to me.

  Maybe this is from V2R1 when there was no BIGINT yet. An integer might easily run out of number when the default batch value of 100.000 is used:  


  2000 AMPs * 100.000 = 200.000.000  


  After 10 restarts it hits the limit.  


  So the actual decision is just BIGINT vs. DEC(18,0). Which one to choose, see above.  



Thanks,

Boris Mogilevsky,
Teradata Consultant



     
  <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