Archives of the TeradataForum
Message Posted: Mon, 25 Jul 2005 @ 15:25:04 GMT
| Subj: || || ALTER TABLE of a 400 million row table |
| From: || || Hassinger, Bill |
We are adding an attribute to a 400 million row table. We usually do a create new table -> insert -> rename process to modify the
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.