closed by
377 views
2 votes
2 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 contain 100000 tupples stored in a sequential file sorted on attribute B. Each block can hold 10 R tupples or 10 S tupples. Which one of the following index is most appropriate for answering query (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
0 answers
2
cidacoder asked Dec 8, 2018
288 views
If NO ATTRIBUTES are common in both relations (R and S) then the result of natural join is ??a. Empty relation.b. Cartesian Product of the relations.
1 votes
1 votes
1 answer
3
Abhisek Tiwari 4 asked Nov 29, 2018
797 views
consider $r1(A,B,C),r2(C,D,E)$ and $r3(F,G)$ with primary key $A,C,F, r1$ has $150 ,r2$ has $100$ and $r3$ has $75$ tuples the number of tuples in $r1$ natural join $r2$ ...
3 votes
3 votes
1 answer
4
Manu Thakur asked Oct 24, 2017
1,180 views
Which one is the more suitable answer for the following question, equijoin or natural join?