Archives of the TeradataForum

Message Posted: Tue, 22 Apr 2003 @ 20:47:42 GMT

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

Hi Mei,

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.

Daniel O'Hara
Project Manager
Teradata Division

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