This type of index has a hierarchical tree structure. When Oracle accesses the index, it starts with the top node called the root (or header) block. It uses this block to determine which second-level block (often referred to as a branch block) to read next. The second-level block points to several third-level leaf nodes that contain a
ROWID and the name value.
Share this highlighthttp://www.safaribooksonline.com/a/pro-oracle-database/3894/