Multiple choice technology databases

Which index will be beneficial to create on the column Gender of a table name employee which permits entry of only two values (M/F)?

  1. Compressed Index

  2. Function based Index

  3. Bitmap Index

  4. B*-Tree index
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

Bitmap indexes are ideal for columns with low cardinality (few distinct values) like Gender which has only two values (M/F). Unlike B-Tree indexes which store each row entry separately, bitmap indexes use a single bitmap per distinct value, making them very efficient for low-cardinality columns in data warehousing scenarios.

Keep practicing — related questions