build1 distinct publisher
The INCLUDE clause moved one column out of a Postgres B-tree's key space
PostgreSQL has done index-only scans since 9.2, six major releases before INCLUDE shipped, so covering was never the thing INCLUDE fixed. What it changes is indnkeyatts, the count of columns the index treats as key.
Publishers:dev.to
Reality
- Evidence74
- Adoption
- Insufficient
- Hype gap−8
- Incentives20
- Confidence