Teradata Join Strategy: The Benefits and Costs of Merge and Product Join Methods Widely read
Teradata uses different join methods and data-placement strategies. Rows to be matched must meet at the executing AMP, which can require duplication, redistribution or sorting. Some methods need less preparation than others, but lower preparation cost does not mean zero geography or resource cost. We should consider the following costs in the join strategy: The …
