Archives of the TeradataForum

Message Posted: Thu, 13 Mar 2003 @ 16:39:14 GMT

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

Srini,

Do a multi statement request instead. The UNION builds a large spool file before inserting the data.

INSERT INTO TABLE_EMPTY
SELECT * FROM TABLE --- (40 million rows table)
;INSERT INTO TABLE_EMPTY
SELECT* FROM TABLE1; --- (18 million rows table)

Yonina

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