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


Correct Option: D

Find more quizzes: