Multiple choice technology databases

A Partitioned Primary Index should be used for what two reasons? (Choose two)

  1. It is the Primary Key of the table, which guarantees uniqueness

  2. It allows instantaneous dropping of old data and rapid addition of new data

  3. It avoids full table scans without the overhead of a secondary index.

  4. It places all data in a specific range on the same AMP.
Reveal answer Fill a bubble to check yourself
C,D Correct answer
Explanation

PPI provides two key advantages: (C) It enables efficient range queries and eliminates full table scans without requiring a secondary index structure, and (D) It ensures all data within a specific range is stored on the same AMP, improving range query performance. Option A is incorrect because NUPI, not PPI, guarantees uniqueness. Option B is incorrect - while PPI facilitates data removal/addition by partition, it's not instantaneous.

Keep practicing — related questions