Archives of the TeradataForum
Message Posted: Tue, 22 Apr 2003 @ 20:47:42 GMT
| Subj: || || Re: Is it possible to modify table? |
| From: || || OHara, Daniel |
This will take a lot of space if you do it all at one. You will have the bases table a version in spool and the new table existing all at
once. If you can't do this you could consider doing it a chunk at a time and doing merge joins. This will take longer but if you don't
have enough MaxPerm there may be no choose.