1
SQLAdvanced#indexes#performance
SQLAdvanced#indexes#performance
What is a covering index?
An index that contains every column a query needs, so the engine answers the query from the index alone without touching the table (an index-only scan).
Example
CREATE INDEX idx_cover ON orders(customer_id, order_date, total); SELECT order_date, total FROM orders WHERE customer_id = 7; -- index-only