Re: index clarification

From: Kevin Closson <>
Date: Thu, 30 Aug 2012 10:28:28 -0700 (PDT)
Message-ID: <>

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

 From: "Sheehan, Jeremy" <> To: "" <> Cc: ORACLE-L <> 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. 



-----Original Message-----
From: [] On Behalf Of Alex Fatkulin Sent: Thursday, August 30, 2012 11:05 AM To: Sheehan, Jeremy
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 <> 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
> --

Alex Fatkulin,


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

Original text of this message