Open
Description
Radix hash join is a join algorithm that partitions input data of both sides into small buckets that can fit CPU cache, to improve the performance of hash join.
In opposite to radix hash join, we are using a shared hash table fashion now, which cannot utilize with CPU cache as good as radix hash join but works well with our Processor execution engine.
It will be nice if we can provide an option to use radix hash join in a query.