Which database index type is best suited for range queries like 'BETWEEN' or 'greater than'?
- Hash Index
- B-Tree Index
- Bitmap Index
- Inverted Index
Answer: B-Tree Index
B-Tree indexes maintain sorted data and allow efficient range queries, equality searches, and ordered retrieval. Hash indexes are optimal only for exact match lookups. Bitmap indexes work well for low-cardinality columns. Inverted indexes are used in full-text search engines.