JoinAlgorithm.LeftHash (3) is an enumeration that specifies the join algorithm to be used in the join operation. It is a member of the JoinAlgorithm.Type and indicates that the algorithm buffers the left rows into a lookup table and streams the right rows. For each right row, the matching left rows are found via the buffered lookup table. This algorithm is recommended when the left table is small and most of the rows from the right table are expected to match a left row.
Examples
The LeftHash join algorithm is recommended when Table1 table is small and most rows from Table1 match rows in Table2.
= Table.Join(
Table1,
{"A1"},
Table2,
{"A2"},
JoinKind.Inner,
JoinAlgorithm.LeftHash // performs a join with the LeftHash algorithm
)Related enumerations
Other related enumerations are:
- JoinAlgorithm.Dynamic
- JoinAlgorithm.LeftIndex
- JoinAlgorithm.PairwiseHash
- JoinAlgorithm.RightHash
- JoinAlgorithm.RightIndex
- JoinAlgorithm.SortMerge
Applies to
Here’s a list of functions that work with JoinAlgorithm.Type:
