O'Reilly logo

Microsoft Azure SQL Data Warehouse - Architecture and SQL by Todd Wilson, Tom Coffing

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 4 – The Technical Details

“In the end we’ll remember not the words of our enemies, but the silence of our friends.”

– Martin Luther King, Jr.

Every Node has the Exact Same Tables

image

To get perfect parallelism, every node has the exact same tables, but if the table is hash distributed then the node holds different rows. As a matter of fact, each node has eight parallel processing distributions that each has their own disk. This means that if a table is hash distributed then each distribution has the same tables, but each holds different rows. If a table is replicated then each node holds the table in its entirety and every node has an exact ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required