Which scenario benefits MOST from adding a database index?
Answer options
A
A table with 10 rows that is rarely queried
B
A column frequently used in WHERE clauses on a large table
C
A column that stores large TEXT/BLOB data
D
A table where most operations are INSERT
Correct answer: A column frequently used in WHERE clauses on a large table
Detailed Solution & Conceptual Analysis
This question has been retained as-is due to its unique context.
Key Engineering Takeaway
In Database Management, understanding the underlying mechanics of SQL is critical for writing performant, bug-free production code and passing rigorous technical architecture reviews.