Skip to content

Glossary: PostgreSQL Beyond the Basics

Covering index

Also written: INCLUDE

An index that holds every column a query needs, by adding extra columns with `INCLUDE`. Those columns are stored but not sorted or searched, and they let the query use an Index Only Scan.

Where the book teaches it

Related terms

Index Only ScanVisibility map