Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 19 May 2016 @ 09:04:35 GMT


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


Subj:   Alter Table - Add Columns
 
From:   Sridhar K

Dear Forum,

Could you please advise why Teradata Alter table statements for adding new columns takes lot of time for Large tables.

I think this is normal if we are giving some default values where it as to rewrite the entire table.

Will the same process happens even if there are no default values while adding columns?


Thanks & Regards,

Sridhar K



     
  <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