124 views
1 votes
1 votes
consider two relations R(A,B,C) and S(B,D) with R contains 5000 tupples stored in a sequential file sorted on attribute A and S contain 10000 tupples stored in a sequential file sorted on attribute B.Each block can hold 10 R tuples or 10 S tupples.which one of the following is most appropriate for answering query R join S?

A)A dense index on R.B

B)A sparse index on R.B

C)A dense index on S.B

D)A sparse  index on  S.B

Please log in or register to answer this question.

No related questions found