SQL Data Warehouse now powered by instant data movement
Published date: July 16, 2018
Azure SQL Data Warehouse is now powered by Instant Data Movement (IDM) technology that allows for extremely efficient movement between data warehouse compute nodes. At the heart of every distributed database system is the need to align two or more tables that are partitioned on a different key to produce a final or intermediate result set. IDM accelerates this movement, resulting in faster query performance. Azure SQL Data Warehouse customers will now enjoy at least two times faster query performance from their workloads, making this the fastest data warehouse in the cloud.