Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

how B-Tree indexes grows

Salman QureshiFeb 13 2004 — edited Jun 2 2004
i have a general question...i have read that B-Tree index grows as follows

when half of the index block is filled...it splits into two index bloks and data is now half half in both index blocks...i don't understand this...if this is true then it means that each index block will be half empty always...kindly someone guide me that is this true because i have read this in oracle xertification book published by oracle...or am i missunderstanding this...
regards
Salman
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 30 2004
Added on Feb 13 2004
14 comments
2,080 views