Computer Science · Database Systems
Which indexing technique is best suited for low-cardinality columns (such as Gender or Status) in a data warehouse fact table?
Verified Solution4 OptionsUpdated: October 2026👁️1 View
Share:
- 1Full-text index, for complex pattern matching of text strings
- 2Hash index, for exact equality matches only
- 3Bitmap index, for efficient bitwise operations and compression of repeating values✓
- 4B-Tree index, to handle large ranges of unique values
Correct answer
Bitmap index, for efficient bitwise operations and compression of repeating values
Download Single Question PDF
Save this question and verified answer as a clean study sheet with live clickable link.
👥
Share with Friends & Study Groups
Challenge your peer aspirants on WhatsApp or Telegram to solve this question!
Online Test Series
Start Free Mock Test →Preparing for Computer Science?
Practice full-length mock tests with real exam timers, instant score analysis, and all-India ranking.
Chapter Practice
Practice Database Systems MCQs →Want more practice questions on Database Systems?
Solve complete topic-wise tests with detailed solutions on GkGet.
Related Practice Questions
Recommended practice questions in Computer Science · Database Systems