How Oracle uses PCTFREE on indexes for inserting

From: Carlos Netto <Carlos.Netto_at_ibase.org.br>
Date: Sat, 22 Oct 94 23:47:00 -0300
Message-ID: <2aa.343.846%mpcbbs_at_ibase.org.br>

Guys,

I read at Oracle manual (Sorry, I don' t remember which one and I'm at home now) that when you're inserting a row, and the free space at the block where the key will be inserted isn't big enouth, Oracle creates a block chaining.

I couldn't believe! Everybody that knows B-Tree algorithms knows that when there is no more space, we need to split the block. I think that's a mistake at Oracle manual. What do you think?

Regards,

----->>>>>>>>>>>> Don't reply. Reply will not work! <<<<<<<<<<<<<<----

|---------------------------------------------------------------------------|


|  Softex 2000 member           | Brazil, Sao Paulo state, Campinas city    | 


=============================================================================

----->>>>>>>> I'll register my Silver only after bug fixes. <<<<<<<-----

Evaluation copy of Silver Xpress. Day # 120 --- via Silver Xpress V4.01P [NR]

User Name: Carlos Netto - ( %mpcbbs_at_ibase.org.br ) This message was processed by RAuucp from Merlin Systems Inc.

Received on Sun Oct 23 1994 - 03:47:00 CET

This message: [ Message body ]
Next message: Thomas B. Cox: "Re: Which Book is best?"
Previous message: Offshore Digital Services: "Powerbuilder, SQL Server(NTAS), Oracle 7.0 (NLM)"
In reply to: Matt Connors: "Re: PCTFREE on indexes"
In reply to Carlos Netto: "Re: Split this newsgroup!"
Next in thread: Sandor Nieuwenhuijs: "Re: ODBC-driver for remote ORACLE"

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

Original text of this message