Multiple choice technology databases

Reading the rows using Unique Secondary index is

  1. One or Two AMP operation depends on the base row location

  2. Always two AMP operation irrespective of the base row location

  3. Many AMP operation

  4. All AMP operation
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

A Unique Secondary Index typically involves a two-AMP operation: one AMP to access the index subtable (which contains the PI value), then a second AMP to retrieve the base row using that PI value. However, if the index row and base row happen to reside on the same AMP, it becomes a single-AMP operation. The exact number depends on row location.

Keep practicing — related questions