Multiple choice technology databases

If the value in a column is not unique then which index is used ?

  1. bitmap indexes

  2. b*-tree indexes

  3. composite unique index

  4. cluster index
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

Bitmap indexes are ideal for columns with low cardinality (non-unique values) because they store bitmaps efficiently for repetitive values. B-tree indexes work better for unique or high-cardinality columns. A composite unique index would require unique values, and cluster index is not the standard term for non-unique column indexing.

Keep practicing — related questions