Why CTAS statement is so fast in Azure SQL DW?

Question

I have noticed that Create Table As Select (CTAS) in SQL Data Warehouse statements are extremely fast compared to Select into statement.

I want to know what magic microsoft did to make it so fast?

score -1 · Answer 1 · answered Mar 26 '19 at 19:33

-1

The magic is: Polybase with minimal transaction loging

answered Mar 26 '19 at 19:33

Diego Carrillo

1 Answers1