Hashjoin Operator Vectoriz ation Optimiz ation
XU Qingyue
HE Qingfa
JIANG Zhiyong
ZHAO Diankui
Abstract：For Hashjion performance bottlenecks ,in order to improve database performance ,accelerate query response capability ,Hashjoin operator is optimized through vectorization method .Vectorization is known as Batch .It is for a row it‐eration ,the proposed pipeline operation and processing systems currently exist in the database optimization ideas .The vec‐torized implementation of the build phase uses vectors of size as input and allows arbitrary column combinations in the input . Actuators carries out query plan tree ,each iteration operator in vector execution unit is batch of tuples rather than in units . The simulation results obtained final batch operator to speed up the processing speed Hashjoin nearly 30 times ,In conclusion Hashjoin operator of analysis involves Hashjoin query performance greatly improved .
Keywords：hashioinvectorizedhash-tableoperator
Publication Date：2014-01-01
Online Publishing Date：2025-08-15(First online date of this platform, not the publication date of the document)
Pages：5( 2041-2044,2211 )