Question: ( 1 0 points ) Suppose that Artist ( A ) has 9 0 0 0 tuples stored in 1 0 0 disk blocks and

(10 points) Suppose that Artist (A) has 9000 tuples stored in 100 disk blocks and Recorded_by (R) has 60000 tuples stored in 600 disk blocks.
The following information is provided for access paths:
102 buffer caches (pages) are available.
The relation Recorded_by has the secondary Index on aID with index level =3
The relation Artist has the secondary index on aID with index level =2
Each Artist tuple matches with exactly 4 Recorded_by tuples.
What is the IO costs for the join Artist |||>||| Recorded_by: Artist.aID = Recorded_by.aID using
(a) index based nested loop join A|||>|R||
(b) index based nested loop join R|||>|A||
(Show all work)
( 1 0 points ) Suppose that Artist ( A ) has 9 0

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