Re: Does Oracle store values in indices?

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

Are there any plans to have something like this? I mean overwriting storage 
manager.

-- 
Sincerely Yours,
Denis Perchine

----------------------------------
E-Mail: dyp@perchine.com
HomePage: http://www.perchine.com/dyp/
FidoNet: 2:5000/120.5
----------------------------------