index clarification

From: "Sheehan, Jeremy" <JEREMY.SHEEHAN@xxxxxxxxxxxxxxxxx>
To: Oracle - L <Oracle-L@xxxxxxxxxxxxx>
Date: Thu, 30 Aug 2012 10:36:58 -0400

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

Follow-Ups:

Re: index clarification
From: Paul Drake

RE: index clarification
From: Mark W. Farnham

Re: index clarification
From: Alex Fatkulin

References:
- listener patch
  - From: John Smith
- Re: listener patch
  - From: Andrew Kerber
- Re: listener patch
  - From: John Smith

index clarification

Other related posts: