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