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 tuples or records stored in disk blocks and the Reserve table has tuples or records stored in disk blocks.
Let S be Sailor and let R be Reserve.
The following information is provided for access paths:
buffer caches pages are available.
The Sailor table has the secondary index on sid with index level
The Reserve table has the secondary index on sid with index level
Each Sailor tuple matches with exactly 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
None of the above
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
