From oracle-l-bounce@freelists.org Fri Mar 26 07:21:56 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i2QDLsM14802 for ; Fri, 26 Mar 2004 07:21:54 -0600 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air189.startdedicated.com (8.11.6/8.11.6) with ESMTP id i2QDLro14796 for ; Fri, 26 Mar 2004 07:21:54 -0600 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 98F29390A65; Fri, 26 Mar 2004 08:19:08 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 06846-21; Fri, 26 Mar 2004 08:19:08 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id E4E33390AAB; Fri, 26 Mar 2004 08:19:07 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Fri, 26 Mar 2004 08:17:55 -0500 (EST) X-Original-To: oracle-l@freelists.org Delivered-To: oracle-l@freelists.org Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id F1C12390A72 for ; Fri, 26 Mar 2004 08:17:54 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 06846-05 for ; Fri, 26 Mar 2004 08:17:54 -0500 (EST) Received: from MXR-6.estpak.ee (ld1.estpak.ee [194.126.101.98]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 694DB390A6A for ; Fri, 26 Mar 2004 08:17:54 -0500 (EST) Received: from localhost (localhost [127.0.0.1]) by MXR-6.estpak.ee (Postfix) with ESMTP id CBE0912F74 for ; Fri, 26 Mar 2004 15:25:18 +0200 (EET) Received: from MXR-6.estpak.ee ([127.0.0.1]) by localhost (Relay6 [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 18070-10 for ; Fri, 26 Mar 2004 15:25:18 +0200 (EET) Received: from porgand (217-159-135-243-dsl.kvm.estpak.ee [217.159.135.243]) by MXR-6.estpak.ee (Postfix) with SMTP id 7A0D912F6F for ; Fri, 26 Mar 2004 15:25:18 +0200 (EET) Message-ID: <036101c41335$c77d7960$f3879fd9@porgand> From: =?windows-1257?Q?Tanel_P=F5der?= To: References: <200403172043.i2HKhIK32750@mail-fe75.tele2.ee> Subject: Re: Maximum height of an Oracle B-tree index Date: Fri, 26 Mar 2004 15:25:16 +0200 MIME-Version: 1.0 Content-Type: text/plain; charset="windows-1257" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2800.1158 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165 X-Virus-Scanned: by amavisd-new-20030616-p7 (Debian) at neti.ee X-Virus-Scanned: by amavisd-new at freelists.org X-archive-position: 1884 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: tanel.poder.003@mail.ee Precedence: normal Reply-To: oracle-l@freelists.org X-list: oracle-l X-Virus-Scanned: by amavisd-new at freelists.org > 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@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 -----------------------------------------------------------------