JoinAlgorithm.RightIndex (6) is an enumeration that specifies the join algorithm to be used in the join operation. It is a member of the JoinAlgorithm.Type and represents an algorithm that, in batches, uses the keys from the right table to do predicate-based queries against the left table, recommended when the left table is large, supports folding of Table.SelectRows, and contains few rows that are expected to match a right row.
Examples
The RightIndex join algorithm is recommended when Table1 is large, supports query folding and contains few rows of Table2:
= Table.Join(
Table1,
{"A1"},
Table2,
{"A2"},
JoinKind.Inner,
JoinAlgorithm.RightIndex // performs a join with the RightIndex algorithm
)Related enumerations
Other related enumerations are:
- JoinAlgorithm.Dynamic
- JoinAlgorithm.LeftHash
- JoinAlgorithm.LeftIndex
- JoinAlgorithm.PairwiseHash
- JoinAlgorithm.RightHash
- JoinAlgorithm.SortMerge
Applies to
Here’s a list of functions that work with JoinAlgorithm.Type:
