TestSeries
[closed]

in Databases closed by
165 views
1 vote
1 vote
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)

in Databases closed by
165 views

Related questions