Skip to Main Content

SQL & PL/SQL

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!

Levels in Index

Rahul_IndiaJul 8 2014 — edited Jul 8 2014

What are levels in index?

http://www.orafaq.com/node/1403

Can anyone just explain this example in a bit more clear way

To find the name Gallileo in this b-Tree phone book, we:

  • Read page 1. This tells us that page 6 starts with Fermat and that page 7 starts with Hawking.
  • Read page 6. This tells us that page 350 starts with Fyshe and that page 351 starts with Garibaldi.
  • Read page 350, which is a leaf block; we find Gallileo's address and phone number.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 5 2014
Added on Jul 8 2014
11 comments
3,068 views