RE: [HACKERS] Does Oracle store values in indices?

[Mikheev, Vadim]

> > The reason you have to visit the main table is that tuple validity
> > status is only stored in the main table, not in each index. 
> > See prior discussions in the archives.
> 
> But how Oracle handles this?

Oracle doesn't have non-overwriting storage manager but uses
rollback segments to maintain MVCC. Rollback segments are used
to restore valid version of entire index/table page.

Vadim