Physical Demonstration of
Co-clustered Performance
•Two million-row tables, joined one-to-one, matching rows created in the same order, reading the most-recent 1% of the rows:
•
Hash
Nested-Loops
Join Type
  6.7
  0.74
Time/s
 12972
 30302
   LIO
 1751
   314
   PIO