closed by
763 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 tuples stored in a sequential file sorted on attribute A and S contain 100000 tuples stored in a sequential file sorted on attribute B. Each block can hold 10 R tuples or 10 S tuples. Which one of the following index is most appropriate for answering query  R (natural Join) S (Assume index always stored in memory)
closed by

Related questions

1 votes
1 votes
1 answer
1
learner_geek asked Jan 24, 2018
1,261 views
My answer is not matching with any of the option.so what is the correct answer
2 votes
2 votes
1 answer
2
iarnav asked Nov 27, 2017
1,350 views
Please kindly explain Natural Join by taking your own handmade example in layman terms. Thank you!
2 votes
2 votes
1 answer
4
rahul sharma 5 asked Jan 5, 2017
976 views
Say I have two tables and they have some attributes in common, assume x is common, now will x will appear once in the output or twice for following cases? Natural joinCro...