JoinAlgorithm.LeftHash

Updated on

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
)

Other related enumerations are:

Applies to

Here’s a list of functions that work with JoinAlgorithm.Type:

Contribute » | Contributors: Rick de Groot