Maximum height of an Oracle B-tree index

From: Richard Foote <richard.foote_at_bigpond.com>
Date: Wed, 10 Mar 2004 00:18:59 +1000
Message-ID: <025701c405e1$777d7e30$0100000a@FOOTE>

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_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html

---

Received on Tue Mar 09 2004 - 07:12:18 CST