Question: Question 4 A B - tree index has the height of 4 ( including the root ) , stored on disk using Alternative ( 2
Question
A tree index has the height of including the root stored on disk using Alternative for data entries. The number of data entry pages is and the number of data record pages is and the number of data records is Suppose that the search key value matches of data records in the file. What is the IO cost in page of retrieving the records matching the search key using the index under the following two cases:
The index is clustered.
The index is unclustered.
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
