Re: Handling of indexes

Dale DeRemer wrote:
>
> I know that Oracle indexes are a literal subset of the original table data.
> What I don't know is how Oracle keeps track of the indexes, and assures
> updates are propogated to the indexes. Are there pointers? If so, where are
> they, in the system tablespace, or buried in the tables themselves?
> This isn't critical, just something I was kicking around.
> Thanks.

Chapter 10 in the Concepts guide (docs.oracle.com) explains all that and more ...

hth
connor

-- 
Connor McDonald
Co-author: "Mastering Oracle PL/SQL - Practical Solutions"
Co-author: "Oracle Insight - Tales of the OakTable"

web: http://www.oracledba.co.uk
web: http://www.oaktable.net
email: connor_mcdonald_at_yahoo.com


"GIVE a man a fish and he will eat for a day. But TEACH him how to fish,
and...he will sit in a boat and drink beer all day"

------------------------------------------------------------