Include All Queried Columns

Back to Covering Indexes

A covering index includes all columns needed by a query in the index itself, so the query can be satisfied entirely from the index without accessing the base table.

relational-databases indexing covering