Multiple choice technology databases

You need to create an index on the PASSPORT_RECORDS table. It contains 10 million rows of data. The key columns have low cardinality. The queries generated against this table use a combination of multiple WHERE conditions involving the OR operator. Which type of index would be best for this type of table?

  1. Bitmap

  2. Btree

  3. Unique

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

Bitmap indexes are highly efficient for columns with low cardinality (few unique values) and are exceptionally well-suited for queries that combine multiple WHERE conditions using logical operators like OR and AND, as they allow fast bitwise operations.

Keep practicing — related questions