Beginner
System Design
Q7 / 100
What is a "database index" used for?
Correct! Well done.
Incorrect.
The correct answer is A) To speed up data retrieval operations by providing a faster lookup structure, at the cost of additional storage and slower writes
A
Correct Answer
To speed up data retrieval operations by providing a faster lookup structure, at the cost of additional storage and slower writes
Explanation
Indexes (often B-trees) allow the database to find rows matching a query without scanning the entire table, significantly speeding up reads at some cost to write performance.
Progress
7/100