Multiple choice technology databases

Primary index value can be changed

  1. At a cost of row redistribution

  2. At a cost of table recreation

  3. When the table is empty

  4. None of the above
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

Changing a Primary Index value in an existing row causes the row to be redistributed to a different AMP because the Primary Index determines data distribution. This requires physically moving the row, which has a performance cost. Teradata will delete the row from the original AMP and re-insert it at the new AMP. Option A correctly describes this cost.

Keep practicing — related questions