Hello @sakuraime ,
Thanks for the ask and using thge forum .
Since you mentioned that you do not want to create a new one , you should not consider the below will create the table .
- CREATE TABLE … AS SELECT …
INSERT INTO … SELECT FROM … : This is a logged event as so it will be slower the below ones .
BULK INSERT : This is minimally logged and so its will be slower then BCP .
BCP should be the fastest among these .
Polybase shoule be the fastest as polybase automatically parallelizes the data load process