Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: question on retrieving rows
Hi Jim & Rene
Thanks alot for your explanations.
Cheers,
Andi
-- Problems in Windows - reboot Problems in Linux - be root "andi" <andihp_at_flashmail.com> wrote in message news:16ce60f4.0303160531.61550749_at_posting.google.com...Received on Mon Mar 17 2003 - 02:57:28 CST
> Hi,
> sorry to confuse you. newbie here :P
> like u said, lets say 1 or more rows are on a particular block, and
> off course oracle should know the block location for these rows before
> it retrieve them. My question is from where does oracle get this
> information that these rows are resided on that block? (and how if the
> table is not indexed?)
>
>
> TIA,
> andi
>
>
> "Jim Kennedy" <kennedy-down_with_spammers_at_attbi.com> wrote in message
news:<tkTca.96752$eG2.13965_at_sccrnsc03>...
> > Note sure I understand the question. The data is stored in blocks. So
in a
> > block there are 1 or more rows. If you are accessing the data via some
> > index then the index has the address of the block and the row in the
block
> > as part of the index (row id)
> > Jim
> >
> > --
> > Replace part of the email address: kennedy-down_with_spammers_at_attbi.com
> > with family. Remove the negative part, keep the minus sign. You can
figure
> > it out.
> > "andi" <andihp_at_flashmail.com> wrote in message
> > news:16ce60f4.0303151947.6d414040_at_posting.google.com...
> > > Hi All,
> > > how does oracle know the starting and ending blocks number of
> > > particular tables' rows ?
> > >
> > > TIA,
> > > andi