Archives of the TeradataForum
Message Posted: Wed, 28 May 2003 @ 14:51:14 GMT
| Subj: | | Re: Alter table vs. create copy for add column |
| |
| From: | | Doug Cox |
Exactly Michael! I would always make a backup of a production table before an Alter to backout with - I'm just paranoid like that. So
if I do that I'm still wasting the space but at least I could backout.
To save space I'd insert into the new table without any indecies except the primary. Then check out to see if the insert worked - drop
the old one - rename the new one then put the NUSI/USI back... Maybe even drop the secondary indecies off the original table during the
process as well to save space..
Like I said before - this scenario really depends on many things.. Space - Timing - user access...
Doug
| 
