liveBook · Manning

Covering index

A covering index is an index containing all columns needed to evaluate and return a query, avoiding access to the base table.

How 2 Manning books explain it

100 SQL Server Mistakes and How to Avoid Them

A covering index is an index containing all columns needed to filter, join, and return a query's results, thereby avoiding a lookup of the base table.

How it is used
Optimizes narrowly defined queries by returning required columns directly from a nonclustered index.
How deep it goes
Explains key and included columns, lookup avoidance, schema fragility, and write costs through concrete SQL examples.
Examples
Demonstrates SalesOrderHeaders filtered by SalesOrderDate and CustomerContacts ordered by email.
What you can do after
Apply it via SQL Server by choosing index keys and INCLUDE columns for a specific query, while weighing read gains against write overhead.

Read how 100 SQL Server Mistakes and How to Avoid Them explains covering index →

Just Use Postgres!

A covering index is an index that stores all columns needed by a query, allowing qualifying results to be returned without reading the table rows.

How it is used
Optimizes frequently executed queries by returning projected values directly from index storage.
How deep it goes
Explains INCLUDE, execution-plan changes, and write-maintenance trade-offs, stopping short of broader index administration.
Examples
Demonstrates a player-statistics query and compares bitmap heap execution with an index-only plan.
What you can do after
Apply it via PostgreSQL CREATE INDEX and verify reduced heap access with EXPLAIN ANALYZE.

Read how Just Use Postgres! explains covering index →

Related concepts

Questions about covering index

What is covering index?

A covering index is an index containing all columns needed to evaluate and return a query, avoiding access to the base table.

Which Manning books explain covering index?

100 SQL Server Mistakes and How to Avoid Them and Just Use Postgres!.

What is the difference between covering index and select star?

A covering index is an index containing all columns needed to evaluate and return a query, avoiding access to the base table. SELECT * is SQL projection syntax that requests every column from the selected table, relation, or other query data source.

What is covering index a kind of?

Covering index is a kind of indexing. Indexing is the process of assigning or using positions, keys, or lookup structures to identify and access elements or records.

What are the parts of covering index?

Covering index includes included column.

These guides are generated from the text of Manning books by Manning's knowledge graph and link to the sections they draw on. The full books are available on liveBook and at manning.com.