Question: Suppose there is a relation r(A, B, C), with a B+-tree index with search key (A, B). a. What is the worst-case cost of finding

Suppose there is a relation r(A, B, C), with a B+-tree index with search key (A, B).

a. What is the worst-case cost of finding records satisfying 10 < A < 50 using this index, in terms of the number of records retrieved n1 and the height h of the tree?

b. What is the worst-case cost of finding records satisfying 10 < A < 50 ∧ 5 < B < 10 using this index, in terms of the number of records n2 that satisfy this selection, as well as n1 and h defined above?

c. Under what conditions on n1 and n2 would the index be an efficient way of finding records satisfying 10 < A < 50 ∧ 5 < B < 10?

Step by Step Solution

3.39 Rating (171 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

a This query does not correspond to a range query on the search key as the condition on the first at... View full answer

blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Database System Concepts Questions!