edited by
642 views
2 votes
2 votes

Here the indexing is done on ordered field so which to use Dense or Sparse because both can be done here ?

edited by

1 Answer

0 votes
0 votes
So if Sparse Indexing is Used the Answer Should Be :-

Record Size = 100B

Block Size is = 1024B

Number of records in a block = 1024/100 = 10

Total blocks required = 30000/10 = 3000.

Now index Content = (Attribute,Block Pointer) = 9 + 6 = 15B

In 1024 Size Block = 1024/15 = 68.

So number of Blocks in 1st level = 3000/68 = 45.

Related questions

0 votes
0 votes
0 answers
1
3 votes
3 votes
1 answer
2
Na462 asked Jan 26, 2019
1,812 views
1 votes
1 votes
1 answer
3
Na462 asked Jun 29, 2018
607 views
Please Solve this question. I didn't understood the question properly so please Make Me as well :) What is meant by Leaf Page ?
1 votes
1 votes
1 answer
4
Na462 asked Jan 19, 2019
923 views