3 ms·
In PostgreSQL a covering index can be configured which includes extra information from columns that aren't part of the searchable index itself. It's documented
by simonw 3y ago
In PostgreSQL a covering index can be configured which includes extra information from columns that aren't part of the searchable index itself. It's documented quite well here: https://www.postgresql.org/docs/current/indexes-index-only-scans.html https://www.postgresql.org/docs/current/indexes-index-only-s...
CREATE INDEX tab_x_y
ON tab(x) INCLUDE (y);