Multiple choice technology databases

What is the main reason to create a reverse key index on a column

  1. The column is populated by sequence

  2. The column contains many different values

  3. The column is mainly used for value range scans

  4. The columns implementing an inverted list attribute.
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

Reverse key indexes are specifically designed for columns populated by sequences. When sequences generate ascending values (1, 2, 3...), normal B-tree indexes cause contention on the rightmost leaf block. Reverse key indexes reverse the bytes of each value, distributing inserts across different leaf blocks and eliminating this hotspot. They're not ideal for range scans (option C) or for high-cardinality columns without sequential insert patterns.

Keep practicing — related questions