Archives of the TeradataForum

Message Posted: Fri, 14 Mar 2003 @ 05:48:17 GMT

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

The following query can be tried instead:

INSERT INTO TABLE_EMPTY
SELECT * FROM TABLE
;INSERT INTO TABLE_EMPTY
SELECT* FROM TABLE1;

This query takes the advantage of multi-stmt insert-select optimization as mentioned in the user documentation.

The details are given in SQL Reference Vol 6, for Fast path Insert-Select.

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