Medium-EasyUnderstandDatabase DesignMultiple Choice

Which type of index is best for a query with a range condition like WHERE age BETWEEN 20 AND 30?

Understand Tests comprehension and ability to explain concepts.

Answer Options

AHash Index
BB-Tree Index
CBitmap Index
DFull-Text Index

Want to see the correct answer?

Get the answer with a detailed explanation, plus practice 21+ more Database Design questions with adaptive quizzes and timed interviews.

See the Answer on Guru Sishya →

This question is from the Database Design topic (System Design).

More Database Design Questions