ConceptCovering Index
Covering Index
An index optimization technique in which all columns required by a query are contained in a single secondary index. The database can then return results directly from the index without performing a table lookup against the clustered index, reducing I/O overhead.
Timeline (last 90 days)
Oct 13
A covering index contains all the information needed for a specific query, potentially allowing the database to avoid accessing the underlying table for each matching row; PostgreSQL can perform index-only scans when visibility information allows.
Unverified50%