Archives of the TeradataForum
Message Posted: Tue, 14 Jul 2015 @ 19:13:08 GMT
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;
|Copyright 2016 - All Rights Reserved|
|Last Modified: 24 Jul 2020|