Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Mon, 25 Jul 2005 @ 15:25:04 GMT


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


Subj:   ALTER TABLE of a 400 million row table
 
From:   Hassinger, Bill

We are adding an attribute to a 400 million row table. We usually do a create new table -> insert -> rename process to modify the structure.

It appears that each row of the altered table is modified along with the DDL tables. When using Alter Table can the process get into a rollback scenerio? Are TJ rows created? Should we drop secondary indexes before the alter table?

We have gotten into extremely long rollbacks in the past, and want to avoid them at all cost.



     
  <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