Training
Module
Combine multiple tables with JOINs in T-SQL - Training
Combine multiple tables with JOINs in T-SQL
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Specifies the join algorithm to be used in the join operation.
Name | 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. |
Training
Module
Combine multiple tables with JOINs in T-SQL - Training
Combine multiple tables with JOINs in T-SQL