Archives of the TeradataForum

Message Posted: Wed, 10 Aug 2005 @ 17:06:22 GMT

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

Aamanth,

If you have enough space, It would probably be faster to create a new table. Insert all the rows with the changes. Then drop and rename the tables.

This also assumes that you can stop loading the table while this is happening. Another advantage to this method is you can add compression or PPI if desired.

Thanks,

Bob Diehl

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