Re:SQLite's Automatic Indexes
by winrid on Wednesday December 28, 2022 @04:15PM
(#34166057)
I see. When I think of a covering index, I think of a covered query, where all query data can be fetched from the index itself. Doesn't the rowid btree just point to an offset on disk where the actual row is? Or is the row itself in the index?
[ Parent
| on HN ]
> Doesn't the rowid btree just point to an offset on disk where the actual row is? Or is the row itself in the index?
The value of the rowid btree is the row.