Multiple choice technology databases

Which index is best suited in case of a table having redundant data

  1. function index

  2. B tree

  3. Bitmap

  4. Primary key

Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

Bitmap indexes are highly efficient for columns with low cardinality (high redundancy/few unique values) because they store bitmaps representing row existence. B-tree indexes are better suited for high-cardinality columns.