Multiple choice

Which of the following options is true when a monotonically increasing sequence number is an indexed column?

  1. Hash-partitioned global indexes are useful.

  2. Hash-partitioned local indexes are better.

  3. Range-partitioned local indexes are better.

  4. Range-partitioned global indexes are better.
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

Hash-partitioned global indexes distribute index entries evenly across partitions, which prevents contention when many inserts happen at sequence-generated values. Range partitioning would create hot spots because sequential numbers map to adjacent ranges. Local indexes inherit the partitioning scheme of the table, so they don't solve the skew problem.

Keep practicing — related questions