Junior — Middle
What type of index is most commonly used in databases?
sobes.tech AI
Answer from AI
Most commonly, databases use a B-Tree index (or its variations, such as B+Tree). This is because the B-Tree index efficiently supports a wide range of operations:
- Fast key-based searches
- Range queries (e.g., finding values between two boundaries)
- Sorting
The B-Tree index is balanced and provides logarithmic access time to data, making it versatile and efficient for most use cases.