RE: index clarification
Date: Thu, 30 Aug 2012 10:42:12 -0400
Message-ID: <C3F905167E081B418BFC63B8668D52FF245EF4807D_at_GOXEXVS03.fplu.fpl.com>
That what I thought! I've been going crazy thinking how it works w/o the rowid! Jeremy
From: edward kosciuszko [mailto:eddiekosmic_at_yahoo.com]
Sent: Thursday, August 30, 2012 10:41 AM
To: Sheehan, Jeremy
Subject: Re: index clarification
You're tech lead is wrong. Of course it contains the ROWID.
From: "Sheehan, Jeremy" <JEREMY.SHEEHAN_at_nexteraenergy.com> To: Oracle - L <Oracle-L_at_freelists.org> Sent: Thursday, August 30, 2012 10:36 AM 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:42:12 CDT