Chapter 5 – How Joins Work Internally

“Only he who attempts the ridiculous may achieve the impossible”

Don Quixote

 

Netezza Join Quiz

image

Do you know which statement above is False?

 

Netezza Join Quiz Answer

image

All statements above are TRUE! Two joining rows have to be in the same memory of a single SPU

 

Redistribution

image

Netezza can redistribute data (temporarily) by re-hashing Customer_Number from the Order_Table. Now, all joining rows will be on the ...

Get The Brilliance of Netezza now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.