Re: Maximum height of an Oracle B-tree index

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Fri, 26 Mar 2004 23:22:31 -0000
Message-ID: <006c01c41389$3bc5c2c0$7102a8c0@Primary>

If you've got about 6 hours and about 24 GB of disk space free, I've got a script that will get you to height 24. You'll have to double the time and space to see what happens if you try to get to 25.

(So far I've built to height 20 in 18 minutes).

Regards

Jonathan Lewis
http://www.jlcomp.demon.co.uk

The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html

April 2004 Iceland http://www.index.is/oracleday.php June 2004 UK - Optimising Oracle Seminar

Original Message ----- From: "Tanel Põder" <tanel.poder.003_at_mail.ee> To: <oracle-l_at_freelists.org> Sent: Friday, March 26, 2004 1:25 PM Subject: Re: Maximum height of an Oracle B-tree index

: > 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 - 17:19:08 CST