← Graph

Covering Index

concept 2 connections

PostgreSQL index that uses INCLUDE to carry extra columns not used for filtering or sorting, purely so that queries selecting those columns can be satisfied from the index alone without a heap lookup. Hasiński calls this under-used in production.

category
pattern
about
Covering Index concept
Mentions INCLUDE columns for index-only scans as under-used.
concept Covering Index
related_to
Covering (INCLUDE) index is a kind of database index.

Provenance

Read by
1 extraction