in Databases
343 views
0 votes
0 votes
Why B or B+ tree is prefer for database indexing rather than AVL tree ????
in Databases
343 views

1 comment

for simple reason in AVL tree a node can have at most 2 child while B and B+ don't have any such restriction so if one node can more then 2 child then B and B+ will result in smaller tree than corresponding AVL tree
0
0

1 Answer

0 votes
0 votes
For searching perspective...its good.

Because it is multilevel indexing O(N2/M) which is less than O(NlogN)

Related questions