My thoughts mirrored Tims. Though after seeing Jonathan Lewis force a very small index to a blevel of 3 with the clever use of data and storage parms and who knows what else, I decided there was a distinct possibility that I was wrong. I've refrained from asking Steve how he did this, but if I see him at dinner this evening, I will find out and report back. :) Jared Live from HOTSOS Tim Gorman <tim@xxxxxxxxxxxxx> Sent by: oracle-l-bounce@xxxxxxxxxxxxx 03/10/2004 06:08 AM Please respond to oracle-l To: <oracle-l@xxxxxxxxxxxxx> cc: Subject: Re: Maximum height of an Oracle B-tree index 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 -----------------------------------------------------------------