I haven’t read it, but “ stop pointing indexes at where the row lives” sounded interesting. So if not the row, what does the index point to instead?
It points to the full primary key (which rarely changes).
It points to the full primary key (which rarely changes).