Question: Reserves ( R ) : 1 0 0 , 0 0 0 tuples stored in 1 , 0 0 0 pages. There are 1 0
Reserves R: tuples stored in pages. There are boats. Each boat is equally poplar ie each has the same number of reservations Sailors S: Stored in pages. There are distinct rating levels to each with the same number of sailors. The sid column takes up of the data size of the Reserves relation. The sid and sname columns take up of the data size of the Sailor relation.a If you are given memory pages, describe an efficient execution plan for the execution tree in the right.b Estimate the processing time in terms of IO cost of your computation strategy. You do not have to include the cost of writing the query result in your analysis.
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
