Question: Task 7 We are doing inner join for three relations R 1 ( A , B ) , R 2 ( B , C )

Task 7
We are doing inner join for three relations R1(A,B),R2(B,C), and R3(C,D).
And we know the following:
For R1: T(R1)=2000,V(R1,A)=50,V(R1,B)=100
For R2: T(R2)=3000,V(R2,B)=200,V(R2,C)=300
For R3: T(R3)=1000,V(R3,C)=90,V(R3,D)=500
Which two relations should we join first to optimize the query execution speed?
Task 7 We are doing inner join for three

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