Question: Instead of the B - tree leaves having pointers to data records, the B - tree leaves hold the records themselves. A block can hold
Instead of the Btree leaves having pointers to data records, the Btree
leaves hold the records themselves. A block can hold ten records, but
on average, a leaf block is full; ie there are seven records per leaf
block.
e The data file is a sequential file, and the Btree is a sparse index, but each
primary block of the data file has one overflow block. On average, the
primary block is full, and the overflow block is half full. However, records
are in no particular order within a primary block and its overflow block.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
