The hash join is an example of a join algorithm and is used in the implementation of a relational database management system.
The task of a join algorithm is to find, for each distinct value of the join attribute, the set of tuples in each relation which have that value.
Hash joins require an equijoin predicate (a predicate comparing values from one table with values from the other table using the equals operator '=').
Read more about Hash Join: Classic Hash Join, Grace Hash Join, Hybrid Hash Join, Hash Anti-join, Hash Semi-join
Famous quotes containing the word join:
“You want to be free and break new ground, speak your mind, fear no man, have the neighbours acknowledge that you’re a good man; and at the same time you want to be a success, make money, join the country club, get the votes and kick the other man in the teeth and off the ladder.”
—Christina Stead (1902–1983)