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!

Index / Root Block - Branch Nodes - Leaf Nodes

538022Feb 21 2007 — edited Feb 22 2007
Hello guys,
i readed many documentations about indeces and performance issues. In many cases i could optimize my queries.

But one thing, i didn't find while i was searching for documents.

What value/fact specifies the following:

1) How much branch nodes can a root block contain/handle?
2) How much leaf nodes can a branch node contain/handle?
3) How much values can a leaf node contain/handle?

It there any rule that specifies at which point the branch block / leaf block should be splitted?

Maybe you can give me a link to a documentation about that topic or explain by yourself....
Thanks :-)

Regards
Stefan
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 22 2007
Added on Feb 21 2007
3 comments
813 views