B-tree 1

[koolage]

can someone explain B-tree in english?
as in: "The clustered index is implementedas a B-tree."
thanks,

koolage

 

[koolage]

sorry everyone, I did find this.

http://en.wikipedia.org/wiki/B-tree

 

[ptheriault]

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.

http://www.bluerwhite.org/btree/

- Paul
- Database performance looks fine, it must be the Network!

 

[koolage]

thanks! that was great!