Question: Let Relation ( ) ( ) 1 2 R A , B , C &R C , D , E have following properties 1 R
Let Relation R ABC &R CDE have following properties R has tuples& R has tuples where tuples of R on one block and tuples of R on oneblock estimate no of blocks access required using each of the following join strategies of R &R :i Merge Join ii Hash Joiniii Block Nested Loop Join iv Nested Loop Join
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
