Re: MVCC and index-only read

On Tue, Nov 18, 2008 at 1:07 PM, Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com> wrote:
> On Tue, Nov 18, 2008 at 1:03 PM, Jonah H. Harris <jonah(dot)harris(at)gmail(dot)com> wrote:
>> On Tue, Nov 18, 2008 at 2:57 PM, Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com> wrote:
>>> Sounds like they're borrowing the code from innodb that does much the
>>> same thing. In Innodb, if a field is indexed, it lives only as an
>>> index, not in the table and an index at the same time.
>>
>> They aren't borrowing anything, Oracle has had this functionality
>> since at least Oracle 8i (1999).
>
> Whoa, calm down Francis. I'm not suggesting they stole it or
> something. Just that they're using the same basic concepts.

Oh, and citation needed. I don't remember seeing anything about
oracle using indexes as sole storage units back in 8i

--
When fascism comes to America, it will be draped in a flag and
carrying a cross - Sinclair Lewis