closed by
120 views
0 votes
0 votes
closed as a duplicate of: file index
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 contains 100000 tupples stored in a sequential file sorted on attribute B. Each block can hold 10R tupples or 10S tupples.which one of the following index is most appropriate for answering query R⨝S?(Assume index always stored in memory).

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
closed by

Related questions

0 votes
0 votes
1 answer
1
Mrityudoot asked Jan 12
148 views
Isn’t F$^{+}$ minimal cover? If C $\rightarrow$ A is already there, then why does augmented CD $\rightarrow$ A needs to be?
0 votes
0 votes
1 answer
2
0 votes
0 votes
1 answer
3