Re: Maximum height of an Oracle B-tree index

From: Tanel Põder <tanel.poder.003_at_mail.ee>
Date: Fri, 26 Mar 2004 15:25:16 +0200
Message-ID: <036101c41335$c77d7960$f3879fd9@porgand>

> I remember a max height of 22 from 8i Data Server Internals materials, but
I can check it when I get home in few weeks.

We'll I finally got home now and I see I remembered the max index height wrong - it's 24 (levels 0 to 23), at least this is stated in 8i DSI materials. But I don't see what kind of clever reason would restrict a B(whatever)-tree structures height at all...

Tanel.

---

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 Fri Mar 26 2004 - 07:21:56 CST