Multiple choice technology databases

The possibilities for the two tables to be joined resides in the same AMP are

  1. The two tables had their same Primary Index

  2. Teradata redistributed one or both tables by rehashing them by thePrimary index in spool

  3. Teradata placed the smaller table on all AMPs

  4. All the Above
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

Teradata provides multiple mechanisms to enable joins to occur on the same AMP: identical primary indexes naturally distribute matching rows to the same AMP; dynamic redistribution can rehash tables during query processing; and duplicating small tables across all AMPs eliminates data movement. All three are valid join optimization strategies.

Keep practicing — related questions