Optimizing Teradata Joins: Tips to Reduce Resource Consumption
Joining tables can be costly since each join requires that the rows being joined are on the same AMP. In cases where the two tables possess different primary indices, copying one or both tables' rows may be necessary, which can cause a high number of I/Os in large