Beginner
Big Data & Data Engineering
Q25 / 100
What is the purpose of a database index?
Correct! Well done.
Incorrect.
The correct answer is A) To speed up data retrieval by providing a faster lookup path, at the cost of extra storage and write overhead
A
Correct Answer
To speed up data retrieval by providing a faster lookup path, at the cost of extra storage and write overhead
Explanation
Indexes act like a lookup structure (often a B-tree) that allows the database to find rows quickly without scanning the entire table.
Progress
25/100