Link to home
Start Free TrialLog in
Avatar of Mr_Shaw
Mr_Shaw

asked on

How many Leaf nodes can each Branch node in a b-tree index have?

How many Leaf nodes can each Branch node in a b-tree index have?
SOLUTION
Avatar of momi_sabag
momi_sabag
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Avatar of Qlemo
Qlemo
Flag of Germany image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Mr_Shaw
Mr_Shaw

ASKER

does it also depend on how much data you can squeeze into a 8k page?
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
which database are you using?
Avatar of Mr_Shaw

ASKER

sql  2005
Avatar of Mr_Shaw

ASKER

thanks