Search:     Advanced search
Browse by category:
C/C++   |   Java   |   Oracle/Database   |   SAP   |   ASP .NET   |   Mainframe-DB2   |   Freshers

What is B-Tree?

Add comment
Views: 61
Votes: 0
Comments: 0
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 nodes: 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 horizontal pointers to other leaf nodes which can be many.
Others in this Category
document What are different normalization forms?
document What is FOREIGN KEY?
document What is a table called, if it has neither Cluster nor Non-cluster Index? What is it used for?
document What are Ranking Functions?
document What is Row_Number()?
document What is Index?
document How to find tables without Indexes?
document How can we rewrite sub-queries into simple select statements or with joins?
document Q: Explain Normal Join
document What’s the difference between a primary key and a unique key?
» More articles



RSS