Re: index clarification

From: Kevin Closson <ora_kclosson_at_yahoo.com>
Date: Thu, 30 Aug 2012 10:28:28 -0700 (PDT)
Message-ID: <1346347708.31303.YahooMailNeo_at_web161703.mail.bf1.yahoo.com>

..and your technical lead doesn't read this valuable list ?

---

 From: "Sheehan, Jeremy" <JEREMY.SHEEHAN_at_nexteraenergy.com> To: "afatkulin_at_gmail.com" <afatkulin_at_gmail.com> Cc: ORACLE-L <oracle-l_at_freelists.org> Sent: Thursday, August 30, 2012 8:43 AM
Subject: RE: index clarification  

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-l
--
http://www.freelists.org/webpage/oracle-l

Received on Thu Aug 30 2012 - 12:28:28 CDT