Recent questions tagged indexing

0 votes
1 answer
93
Records Size in bytes:- 30,75,40,65,50,20 Block Size:- 100 bytesIf unspanning organization is used,then what is % of wastage in disk space?
0 votes
1 answer
94
Does values in Leaf nodes of B+ tree repeats or ever leaf node has an unique value?
2 votes
1 answer
95
Suppose size of block 1000 bytes search key of 12 bytes, pointer size 8 bytes. How many maximum records in DB file which can index by dense B+ tree of 2 levels?
2 votes
0 answers
97
Suppose blocks hold either three records, or Ten (Key,pointer) pairs. As a function of n, the number of records, for dense index.How many levels of index as is appropriat...
0 votes
1 answer
98
0 votes
1 answer
99
4 votes
2 answers
101
pls explain
0 votes
1 answer
102
please can someone explain dense index ,sparse index ,cluster indexing with a proper example instead of theory ?
1 votes
1 answer
104
Given a data file with 100 records per page and 1000 pages and on indexpage capacity of 512 index entries, how deep should be the B+ tree toindex this file.please explain...
3 votes
1 answer
105
2 votes
0 answers
108
2 votes
2 answers
109
2 votes
0 answers
110
1 votes
1 answer
111
1 votes
2 answers
113
0 votes
1 answer
115
Block size 1000 BSearch key 12 BPointer size 8BWhat is max records of DB1) For Dense index B+ tree of 2 level2) For Sparse index B+ tree of 2 levelHow ans will differ , P...
1 votes
0 answers
117
why Multi- level Indexes uses fan out as base of log function
0 votes
1 answer
118
Is it possible to have an Index file which is both dense index and sparse Index?
2 votes
1 answer
119
In the given B-Tree below , insert an index record with key 40 ? (order of b-tree is 4)ANSWER :PLEASE VERIFY ...
6 votes
6 answers
120
A Clustered indexA) is a dense index always.B) is a sparse index always.C) can be either dense index or a sparse index,but not both.D) can be both dense index and sparse ...