It would take a heckuva lot of space, even with DB_BLOCK_SIZE = 512 and PCTFREE=99 on the index, to get BLEVEL over 10... Hat's off to Steve on getting it to 20+... on 3/9/04 7:18 AM, Richard Foote at richard.foote@xxxxxxxxxxx wrote: > Hi All, > > I'm currently writing a rather detailed paper for our local user group on > Index Internals, tentatively titled "Index Internals - Rebuilding The > Truth". I haven't had this much fun with tree and block dumps for quite a > while ;) > > One of the many myths I'm exposing is the "rebuild if index has more than 2, > 3, 4, 42, whatever levels". Now to get an honary mention in the paper (what > more reward can one wish for !!), I would love to know who on the list has > created an index with the greatest height and perhaps a little info on it's > circumstance. > > Steve Adams once mentioned to me creating an index with 20+ levels, can > anyone else come close ? > > Thanks for any replies. > > Richard > > > ---------------------------------------------------------------- > 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 > ----------------------------------------------------------------- ---------------------------------------------------------------- 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 -----------------------------------------------------------------