Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Wed, 19 Mar 2002 @ 21:25:41 GMT

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

Subj:   Re: ALTER TABLE Question
From:   Brian Duane

The ALTER TABLE statement to add an extra column will still require space in the Transient Journal for the before image of each row and will take a long time to execute.

As an alternative, you should consider moving some space to the required database, then creating a new table and populating the new table with an INSERT/SELECT from the old table (plus some default value for the new column).

This will be very fast (block writes, no transient journal). At the end, drop the old table, and move the space back.

  <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: 28 Jun 2020