Re: index clarification
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-lReceived on Thu Aug 30 2012 - 10:04:45 CDT