Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> comp.databases.theory -> Re: dbdebunk 'Quote of Week' comment

Re: dbdebunk 'Quote of Week' comment

From: Marshall Spight <marshall.spight_at_gmail.com>
Date: 26 Aug 2005 23:50:30 -0700
Message-ID: <1125125430.575116.219420@g43g2000cwa.googlegroups.com>


David Cressey wrote:
> "Marshall Spight" <marshall.spight_at_gmail.com> wrote in message
> > > If we were to delete the row, and then
> > > insert another row with a different key, who is to say that the system
> > > didn't reuse the unused row?
> >
> > I use the term "row" as a logical term, not a physical one.
>
> I'm not following you. I *think* I use the term "row" as a logical one as
> well.

I think we're almost entirely in agreement here. I just thought the idea of "reus[ing] the unused row" was really only an issue at the physical level.

> > > In practice, this is only partly true. If the DBMS alters either the
> > > content or the location of a row, it may have to do some index
> maintenance
> > > to reflect that change. But at least a row is unpinned except for the
> pins
> > > in the index.
> >
> > I think I'd just change this a tiny bit to say "In the implementation,
> > this is only partly true."
>
> Agreed, with one more tiny change: "In current implementations, this is
> only partly true"

Perfect!

Marshall Received on Sat Aug 27 2005 - 01:50:30 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US