Handling of indexes

Giganews Newsgroups
Subject: Handling of indexes
Posted by:  Dale DeRemer (dderemer_nospam@agmc.org)
Date: Tue, 25 Jan 2005

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.

Replies