Archives of the TeradataForum
Message Posted: Wed, 28 May 2003 @ 14:51:14 GMT
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...
|Copyright 2016 - All Rights Reserved|
|Last Modified: 27 Dec 2016|