Re: Does Oracle store values in indices?

* Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> [010123 11:17] wrote:
> [ Charset KOI8-R unsupported, converting... ]
> > > > > 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.
>
> We hope to have it some day, hopefully soon.

Vadim says that he hopes it to be done by 7.2, so if things go
well it shouldn't be that far off...

--
-Alfred Perlstein - [bright(at)wintelcom(dot)net|alfred(at)freebsd(dot)org]
"I have the heart of a child; I keep it in a jar on my desk."