closed by
1,038 views
0 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)
Position:
Show:

Related questions

1 1 vote
1 answers 1 answer
2.3k
2.3k views
learner_geek asked Jan 24, 2018
2,322 views
My answer is not matching with any of the option.so what is the correct answer
2 2 votes
1 answers 1 answer
2.2k
2.2k views
iarnav asked Nov 27, 2017
2,173 views
Please kindly explain Natural Join by taking your own handmade example in layman terms. Thank you!
0 0 votes
0 0 answers
994
994 views
GateAspirant999 asked May 12, 2018
994 views
Q.1. Does theta join operator requires following union compatibility requirements?:Same number of columnsDomain of corresponding columns should be sameI feel no, since I ...
2 2 votes
1 answers 1 answer
1.4k
1.4k views
rahul sharma 5 asked Jan 5, 2017
1,352 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...