O'Reilly logo
  • Lucas Reis thinks this is interesting:

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.


Cover of Pro Oracle Database 11g Administration


Index structure