Archives of the TeradataForum
Message Posted: Wed, 19 Mar 2002 @ 21:25:41 GMT
| 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.