The database server uses a B-tree structure to organize index information. B-Tree generally has following types of index pages or nodes:
Root node: A root node contains node pointers to branch nodes which can be only one.
Branch node: A branch node contains pointers to leaf nodes or other branch nodes which can be two or more.
Leaf nodes: A leaf node contains index items and orizantal pointers to other leaf nodes which can be many.
No comments :
Post a Comment