Glossary term
What is covering index? Meaning for developers
An index that holds every column a query needs, so the table itself is not read.
Learn it properly · SQL & PostgreSQLLesson 5: Indexes and EXPLAINHow a B-tree helps, composite, covering and partial indexes, and reading real EXPLAIN ANALYZE plans on a million rows.