Azure SQL DW Performance: CTAS/Partition Switching VS UPDATE/DELETE

(Tim Salch) DML operations can be resource intensive and harmful to CCI indexes in Azure SQL Data Warehouse. The main performance benefit comes from UPDATE & DELETE operations being fully logged and CTAS is minimally logged.

Register to Read