Intermediate
SQL
Q44 / 100
What is the purpose of an INDEX on a column?
Correct! Well done.
Incorrect.
The correct answer is B) To speed up data retrieval operations on that column at the cost of additional storage and slower writes
B
Correct Answer
To speed up data retrieval operations on that column at the cost of additional storage and slower writes
Explanation
An index creates an auxiliary data structure (often a B-tree) that allows the database to find rows matching a condition much faster, but adds overhead to INSERT/UPDATE/DELETE operations.
Progress
44/100