6 votes 6 votes which formula should we use for calculating LEAF node in B+ tree? I. n*(K+r)+b<=block size where n=no of keys k=key size,r=record pointer,b=block pointer II. (n-1)(K+r)+b<=block size Databases databases b-tree tree + – firki lama asked Jan 14, 2017 • edited Dec 24, 2021 by Shubham Sharma 2 firki lama 5.9k views answer comment Share Follow See all 2 Comments See all 2 2 Comments reply nimesh kumar commented Jan 15, 2017 reply Follow Share why option 2 cant be used? 0 votes 0 votes The_Toad_Sage commented Feb 1, 2017 reply Follow Share what will be it's order? n or (n+1) ? 0 votes 0 votes Please log in or register to add a comment.
Best answer 9 votes 9 votes For n keys,each key must be store at leaf level.So 1st option is correct. N*(Key+RecordPointer)+BlockPointer<=Block Size rahul sharma 5 answered Jan 14, 2017 • selected Jan 14, 2017 by vijaycs rahul sharma 5 comment Share Follow See all 2 Comments See all 2 2 Comments reply yankur9 commented Jan 18, 2018 reply Follow Share #reference gate 2007 CS questio 85 0 votes 0 votes Brij Mohan Gupta commented Sep 23, 2019 reply Follow Share 1. For leaf node N*(Key+RecordPointer)+BlockPointer<=Block Size 2. non leaf node it will be N*Key+8(Child_Pointer)≤Block Pointer 0 votes 0 votes Please log in or register to add a comment.