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.


The RightIndex join algorithm is recommended when Table1 is large, supports query folding and contains few rows of Table2:

= Table.Join(
     JoinAlgorithm.RightIndex // performs a join with the RightIndex algorithm

Other related enumerations are:

Applies to

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

BI Gorilla Blog

Last update: August 17, 2023 | Contribute » | Contributors: Rick de Groot
© 2023 BI Gorilla. All rights reserved. Content derived from Microsoft documentation is property of Microsoft Corp.