Details
-
Improvement
-
Status: Open
-
Major
-
Resolution: Unresolved
-
10.0.0
Description
Currently SwissJoin uses 32-bit hash. This means that it will work well only up to around 10M rows in the hash table. Beyond that the hash collisions will keep growing very fast making the hash join impractical to use from performance perspective. Switch to 64-bit hash.