Physical Demonstration of
Non-Co-clustered Performance
•Two million-row tables, joined one-to-one, joined-to matching rows created in random order, reading the most-recent 1% of the driving-table rows:
•
Hash
Nested-Loops
Join Type
    6.7
  49.2
Time/s
 12899
 30223
   LIO
  1592
10029
  PIO
      3737
    20337
CBO “Cost”