Question: ( 1 0 points ) Suppose that Artist ( A ) has 9 0 0 0 tuples stored in 1 0 0 disk blocks and
points Suppose that Artist A has tuples stored in disk blocks and Recordedby R has tuples stored in disk blocks.
The following information is provided for access paths:
buffer caches pages are available.
The relation Recordedby has the secondary Index on aID with index level
The relation Artist has the secondary index on aID with index level
Each Artist tuple matches with exactly Recordedby tuples.
What is the IO costs for the join Artist Recordedby: Artist.aID RecordedbyaID using
a index based nested loop join
b index based nested loop join
Show all work
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
