Covering Index

Indexing

An index containing all columns needed to satisfy a query, allowing the executor to return results directly from the index without accessing the heap table. Created with INCLUDE clause in PostgreSQL 11+.

Related terms