Archives of the TeradataForum

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

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

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