RE: index clarification
Date: Thu, 30 Aug 2012 11:43:23 -0400
Message-ID: <C3F905167E081B418BFC63B8668D52FF245EF48101_at_GOXEXVS03.fplu.fpl.com>
As much as I like being right (especially with his "I've got 20 years experience" attitude), we have an extremely strained working relationship. I'd rather not add fuel to the fire as work has been peaceful lately.
Thanks!
Jeremy
-----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Alex Fatkulin
Sent: Thursday, August 30, 2012 11:05 AM
To: Sheehan, Jeremy
Cc: ORACLE-L
Subject: Re: index clarification
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 -- http://www.freelists.org/webpage/oracle-lReceived on Thu Aug 30 2012 - 10:43:23 CDT