Question

Which of the following is true?

(a) larger the order of B-tree, less frequently the split occurs

(b) larger the order of B-tree, more frequently the split occurs

(c) smaller the order of B-tree, more frequently the split occurs

(d) smaller the order of B-tree, less frequently the split occurs

This interesting question is from B-Trees topic in division B-Trees of Data Structures & Algorithms I

I had been asked this question in homework.

Answer 1

Right option is (a) larger the order of B-tree, less frequently the split occurs

To explain: The average probability of the split is 1/(⌈m / 2⌉ – 1), where m is the order of B-tree. So, if m larger, the probability of split will be less.