In PostgreSQL you add payload columns with INCLUDE; they are stored in the index but not used for sorting. It enables an Index Only Scan.
Covering index
An index that contains every column a query needs, so the table is not read.
In PostgreSQL you add payload columns with INCLUDE; they are stored in the index but not used for sorting. It enables an Index Only Scan.