Archives of the TeradataForum

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

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

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>>