A B+ tree index is built on the key ‘CS’ attribute of the relation ME16. The attribute ‘CS’ is of length 32 bytes, disk blocks are of size 2048 bytes and index pointers are of size 8 bytes. The number of pointers per node is _______.
they have done :
which one to consider true ?
let #keys per block = x
$\therefore$ 32(x) + 8(x+1) <= 2048
$\therefore$ 40x + 8 <= 2048
$\therefore$ 40x <= 2040
$\therefore$ x = 51 (without any doubt)
In d link mentioned below. Yeah. :)