Hi Cary & List , i have been long trying to get a pictorial representation of a simple b-tree index and how it changes as the index grows . Though i read the docs , still i'm not able to say "okay , this is how b-tree index works" . Has anyone got something like what i'm looking for ? Just curious to know : Cary , what does * Nullius in verba * mean ? Regards, Prem. >>-----Original Message----- >>From: oracle-l-bounce@xxxxxxxxxxxxx >> >>You get a new level only if the parent node splits propagate >>all the way >>to the index root node. Jonathan Lewis and Steve Adams have some good >>tests in their courses that use block dumps to show how Oracle >>redistributes keys in branch blocks when nodes split. >> >>Yes, Oracle index nodes are one block apiece. >>Cary Millsap >>* Nullius in verba * ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------