Re: index clarification

From: Alex Fatkulin <afatkulin_at_gmail.com>
Date: Thu, 30 Aug 2012 11:04:45 -0400
Message-ID: <CAMVw97Li=UH2nECL2Rj5o6rf_H=HWAcQgegUUeK4onGgMPLNFQ_at_mail.gmail.com>

The only index (type) which doesn't store a ROWID is a secondary index on IOT (they store UROWIDs instead).

Why didn't you ask the question about finding rows without a ROWID to your technical lead?

On Thu, Aug 30, 2012 at 10:36 AM, Sheehan, Jeremy <JEREMY.SHEEHAN_at_nexteraenergy.com> wrote:
> This may seem like a newbie question, but my technical lead told me something yesterday that was contrary my thinking and assumptions on how indexes work.
>
> I was always under the assumption (from studies and readings) that an index contains the values for the indexed columns and a rowid that points back to the table. My technical lead says that indexes do not have a rowid. Is he right? If it doesn't contain the rowid, how does it relate back to the table?
>
> Thanks in advance...
>
> Jeremy
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>

-- 
Alex Fatkulin,
http://afatkulin.blogspot.com

Enkitec,
http://www.enkitec.com
--
http://www.freelists.org/webpage/oracle-l

Received on Thu Aug 30 2012 - 10:04:45 CDT