Home Page for the TeradataForum
 
 

 

Archives of the TeradataForum





Message Posted: Thu, 28 Feb 2008 @ 16:17:24 GMT





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




Subj:   Impacts of adding column to a large table
 
From:   Longauer Juraj



Hi,

I have a large table (~150 GB) on which I want to add a nullable column using ALTER TABLE command. I am curious how big is the impact on the system performance and availibility of the table duration of the lock, adding NULL to each record etc.


Thanks,

Juraj





     
  <Prev Next>  
<<First
<Prev
Next> Last>>  
 
 
 
 
 
 
 
 
  
 
  Top Home Join Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky 
Last Modified: 30 Jun 2008