↑↓ select ↵ open ⌫ change scope Open full search

PG.CENTER connects PostgreSQL documentation, reference, and ecosystem knowledge. Maintained by Pigsty.

Feature: Covering Indexes for B-trees (INCLUDE)

Allows additional columns to be included in as "non-key" columns in an index, and if requirements are met, can return data from these columns in an index-only scan.

Fore more information, please see the documentation on Index-Only Scans & Covering Indexes.