Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Mon, 19 May 2003 @ 20:24:48 GMT


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


Subj:   Re: Size of count(*) field
 
From:   Doug Cox

We had a similar problem with the Version Column on my last job. It's defined as a SMALLINT - Every time we made a table change it incremented. This table is part of an Active Data Warehouse so we were dropping and recreating indicies every 15 minutes to deal with loads.

This caused the VERSION column to fill up past 32,767 and created a nasty error.

Doug



     
  <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