Comparing
Co-Clustered and Non-Co-clustered
Performance
3737
1.6K-1.8K
13K
6.7
Hash (both)
Non-co-clustered
NL
Co-clustered
Nested Loops
Join Type
49.2
0.74
Time/s
30223
30302
LIO
10029
314
PIO
20337
20337
CBO Cost
Cost
function predicts relative runtimes well in non-co-clustered case!
Co-clustered
case is more important, though, and greatly favors nested
loops!