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
as in: "The clustered index is implementedas a B-tree."
thanks,
koolage
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
- Thread starter koolage
- Start date
- Status
- Thread starter
- #2
koolage
IS-IT--Management
- Jan 3, 2005
- 60
-
1
- #3
ptheriault
IS-IT--Management
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!
Here is a link to a good definition of a BTree index.
- Paul
- Database performance looks fine, it must be the Network!
- Thread starter
- #4
- Status
Similar threads
- Locked
- Question