Covering index (INCLUDE)

A covering index, created with INCLUDE, stores additional columns in the index without using them for the search. A query that only needs those columns can be satisfied by an Index Only Scan, without reading the table, provided the table is sufficiently up to date (visibility map).

Example

CREATE INDEX ON commandes (client_id) INCLUDE (total);

Related concepts

The whole glossary