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:
“We become male automatically because of the Y chromosome and the little magic peanut, but if we are to become men we need the help of other men—we need our fathers to model for us and then to anoint us, we need our buddies to share the coming-of-age rituals with us and to let us join the team of men, and we need myths of heroes to inspire us and to show us the way.”
—Frank Pittman (20th century)