How does Oracle keep B-tree indexes to 3 levels?

From: Ryan <ryan.gaffuri_at_cox.net>
Date: Thu, 5 Feb 2004 22:31:44 -0500
Message-ID: <071501c3ec61$be6d8fe0$a1e16444@ryan2le36ofjce>

I'm taking an academic database class. My professor showed us that when you have a block split and the parent node(s) split, you end up with a new level. I'm assuming oracle 'redistributes' the pointers instead of adding a new level? Are index nodes always one block?

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 Thu Feb 05 2004 - 21:31:44 CST

This message: [ Message body ]
Next message: Juan Cachito Reyes Pacheco: "Re: ORA-01925: maximum of 30 enabled roles exceeded"
Previous message: Mohammad Rafiq: "Re: connect / as sysdba on 9i"
Next in thread: Cary Millsap: "RE: How does Oracle keep B-tree indexes to 3 levels?"
Reply: Cary Millsap: "RE: How does Oracle keep B-tree indexes to 3 levels?"
Maybe reply: Thomas Biju: "RE: How does Oracle keep B-tree indexes to 3 levels?"
Maybe reply: Thater, William: "RE: How does Oracle keep B-tree indexes to 3 levels?"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US