JoinAlgorithm.Type specifies the join algorithm to be used in the join operation.
Enumeration Options
Enumerations simplify the process of selecting options within a function. To specify the JoinAlgorithm.Type, users have the option to either input the below Argument description (which provides more information) or the shorter Value (which provides a more concise representation).
| Argument | Value | Description |
|---|---|---|
| JoinAlgorithm.Dynamic | 0 | Automatically chooses a join algorithm based on inspecting the initial rows and metadata of both tables. |
| JoinAlgorithm.PairwiseHash | 1 | Buffers the rows of both the left and right tables until one of the tables is completely buffered, and then performs a LeftHash or RightHash, depending on which table was buffered completely. This algorithm is recommended only for small tables. |
| JoinAlgorithm.SortMerge | 2 | Performs a streaming merge based on the assumption that both tables are sorted by their join keys. While efficient, it will return incorrect results if the tables aren’t sorted as expected. |
| JoinAlgorithm.LeftHash | 3 | 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. |
| JoinAlgorithm.RightHash | 4 | Buffers the right rows into a lookup table and streams the left rows. For each left row, the matching right rows are found via the buffered lookup table. This algorithm is recommended when the right table is small and most of the rows from the left table are expected to match a right row. |
| JoinAlgorithm.LeftIndex | 5 | In batches, uses the keys from the left table to do predicate-based queries against the right table. This algorithm is recommended when the right table is large, supports folding of Table.SelectRows, and contains few rows that are expected to match a left row. |
| JoinAlgorithm.RightIndex | 6 | In batches, uses the keys from the right table to do predicate-based queries against the left table. This algorithm is recommended when the left table is large, supports folding of Table.SelectRows, and contains few rows that are expected to match a right row. |
Applies to
Here’s a list of functions that work with JoinAlgorithm.Type:
2023-2024 © BI Gorilla. All rights are reserved. Information from Microsoft docs is property of Microsoft Corp. | Privacy Policy