Question: Given this diagram, calculate the join cost given 3 memory page. Explain your reasoning. My guess would be that if I have 3 memory page

Given this diagram, calculate the join cost given 3 memory page. Explain your reasoning. My guess would be that if I have 3 memory page would be 2 on the outer relation Sailors and 1 on the inner relation Reserves so my guess would be 2+(1*188) but others have put 3+(3*188) so I'm confused. Please also do the join calculation assuming that we're giving 4 memory pages. I want to see the difference. Thanks!
 Given this diagram, calculate the join cost given 3 memory page.

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 Databases Questions!