RE: index clarification
Date: Thu, 30 Aug 2012 10:52:32 -0400
Message-ID: <C3F905167E081B418BFC63B8668D52FF245EF4809E_at_GOXEXVS03.fplu.fpl.com>
Thanks, Paul! This helps tremendously!
Jeremy
From: Paul Drake [mailto:bdbafh_at_gmail.com]
Sent: Thursday, August 30, 2012 10:45 AM
To: Sheehan, Jeremy
Cc: Oracle - L
Subject: Re: index clarification
Jeremy,
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)
https://richardfoote.wordpress.com/2010/02/08/index-block-dumps-and-treedumps-part-i-knock-on-wood/
Paul
putting out fire with gasoline.
On Thu, Aug 30, 2012 at 10:36 AM, Sheehan, Jeremy <JEREMY.SHEEHAN_at_nexteraenergy.com<mailto:JEREMY.SHEEHAN_at_nexteraenergy.com>> 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...
Jeremy
--
http://www.freelists.org/webpage/oracle-l
--
http://www.completestreets.org/faq.html
http://safety.fhwa.dot.gov/ped_bike/docs/pamanual.pdf
--
http://www.freelists.org/webpage/oracle-l
Received on Thu Aug 30 2012 - 09:52:32 CDT