Re: index clarification
Date: Thu, 30 Aug 2012 11:04:45 -0400
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
> 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...
-- Alex Fatkulin, http://afatkulin.blogspot.com Enkitec, http://www.enkitec.com -- http://www.freelists.org/webpage/oracle-lReceived on Thu Aug 30 2012 - 10:04:45 CDT