This correspondence proposes two ways to improve the soft-merge based
band join algorithm. The techniques proposed address issues that have
not been previously discussed: to choose a right relation as the inner
relation to achieve better performance and to optimally allocate and
adjust buffer allocations to make the algorithms robust to data skew a
nd estimation errors.