Archives of the TeradataForum

Message Posted: Tue, 14 Jul 2015 @ 19:13:08 GMT

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

Forum - I want to copy 100M records from a table which contains 5.5 B records to another table on the same server. What is the fastest way to accomplish this? Will Insert- select using top be ok? Is there a better way?

     INSERT INTO TABLE2 SELECT 100000000 * FROM TABLE1;

Thanks

Roopalini

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