RE: index clarification

From: Mark W. Farnham <mwf_at_rsiz.com>
Date: Thu, 30 Aug 2012 10:48:47 -0400
Message-ID: <022201cd86be$90850f80$b18f2e80$_at_rsiz.com>

Perhaps this person meant that the index does not contain a rowid like structure for its own contents.

-----Original Message-----

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Sheehan, Jeremy
Sent: Thursday, August 30, 2012 10:37 AM To: Oracle - L
Subject: index clarification

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

--

http://www.freelists.org/webpage/oracle-l Received on Thu Aug 30 2012 - 09:48:47 CDT