569 views
2 votes
2 votes

I have two doubts here

(1)Doubt1-The number of blocks needed to store file must be 3000 and not 2930. Record organisation is unspanned and so 1 block can contain only 10 records. Here in solution, they are trying to fit bytes into blocks and not records and that implies spanned organisation of block.

(2)Doubt2: They asked for the number of accesses using primary index-I considered it to be multi-level(to optimise) block access and hence got 2 level of indexing and therefore 3 block accesses. But they considered only 1 level of primary indexing and gave an answer as $\lceil log_244 \rceil +1$.

I think even if they didn't tell, for purpose of optimisation we can consider multi-level indexing with primary index. What should be the correct answer here?

Please log in or register to answer this question.

Related questions

0 votes
0 votes
0 answers
2
Abhishek Kumar Singh asked Dec 23, 2017
473 views
2 votes
2 votes
0 answers
3
Manu Thakur asked Oct 26, 2017
1,942 views
In the following question, How to know that at first level (base level) index entries will be recorded for a block or for each record?https://gateoverflow.in/2311/gate199...
5 votes
5 votes
2 answers
4
resilientknight asked Sep 20, 2016
491 views
Maximum number of clustered indices one can build for a table with n attributes, which already has a primary index?