> > 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