RE: index clarification

From: Sheehan, Jeremy <>
Date: Thu, 30 Aug 2012 10:52:32 -0400
Message-ID: <>

Thanks, Paul! This helps tremendously!

From: Paul Drake [] Sent: Thursday, August 30, 2012 10:45 AM To: Sheehan, Jeremy
Cc: Oracle - L
Subject: Re: index clarification


Did someone say ... Block Dumps?

"Note this is a Non-Unique index and so the index entries have a specific format that enables each index entry to still be defined in a unique manner. This is effectively achieved by including the rowid as an additional column within each index entry."

(part II from this series)


putting out fire with gasoline.

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...




-- Received on Thu Aug 30 2012 - 09:52:32 CDT

Original text of this message