Question
When does an index cover a query?
Select an option. Your answer will be checked instantly.
Correct Answer: D. When it contains all columns needed to satisfy the query without accessing the base table
Explanation:
A covering index supplies the filter, join, and output columns required by a query.
Avoiding extra lookups can substantially reduce I/O.
Leave a Reply