BCP loads through the head node, so definitely not as scalable as COPY INTO.
Azure synapse : Fastest way to load into Fact table
what's the fastest way to load/insert in to Current fact table(NOT CREATE A NEW ONE) ?
– INSERT INTO … SELECT FROM …
– CREATE TABLE … AS SELECT …
– Polybase
– BCP
– OPENROWSET / BULK INSERT
– COPY INTO …
??
2 answers
Sort by: Most helpful
-
-
HimanshuSinha-msft 19,246 Reputation points Microsoft Employee
2020-12-04T02:28:08.997+00:00 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 processThanks
Himanshu