Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

B-tree 1

Status
Not open for further replies.

koolage

IS-IT--Management
Jan 3, 2005
60
can someone explain B-tree in english?
as in: "The clustered index is implementedas a B-tree."
thanks,

koolage
 
a b-tree index has one root page, two or more branch levels and many leaf pages. the leaf level of a clustered index is the actual data of your table.

Here is a link to a good definition of a BTree index.


- Paul
- Database performance looks fine, it must be the Network!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top