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!

Reg: B-tree index -

915396Aug 23 2013 — edited Aug 27 2013

Hi Experts,

I've got some conceptual doubt in Oracle's B-Tree index. I've read few articles by Richard Foote and other blogs, but still have this confusion:

Considering the Dictionary example for Indexes here, what exactly forms the Root node? I'm not able to get a clear mental image.

Each page of dictionary forms a leaf block, is it?

Please help in understand this basic but 'critical' concept part.

Help much appreciated.

-- Ranit

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 24 2013
Added on Aug 23 2013
18 comments
1,204 views