Multiple choice technology databases

bitmap index should be created on columns which have high cardinality

  1. True

  2. False
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

Bitmap indexes are best for columns with LOW cardinality (few distinct values like gender, status, or boolean flags). They use bitmaps to represent which rows have each value. High cardinality columns (many distinct values) are better served by B-tree indexes, which would be more efficient for that data distribution.

Keep practicing — related questions