Question: Suppose that the Sailor table has 5 0 0 tuples ( or records ) stored in 5 0 disk blocks and the Reserve table has

Suppose that the Sailor table has 500 tuples (or records) stored in 50 disk blocks and the Reserve table has 5,000 tuples (or records) stored in 500 disk blocks.
Let S be Sailor and let R be Reserve.
The following information is provided for access paths:
7 buffer caches (pages) are available.
The Sailor table has the secondary index on sid with index level =1.
The Reserve table has the secondary index on sid with index level =2.
Each Sailor tuple matches with exactly 10 Reserve tuples.
Consider the following block nested loop join: S R
Which one is the IO cost for the join operation ?
Group of answer choices
5,500
6,050
5,050
10,500
None of the above

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock 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 Programming Questions!