Recent questions tagged indexing

1 1 vote
0 0 answers
160
160 views
In relation to Index structures for files which of the following are true?An index is an integral part of the data file.An index can be created in conjunction with virtua...
2 2 votes
1 1 answer
696
696 views
In a relational database, a $\mathrm{B}+$ Tree Index is to be constructed for a relation on a key field. In a $\text{B+}$ Tree, a Node Pointer points to a sub-tree and a ...
9 9 votes
2 2 answers
2.2k
2.2k views
An index in a DBMS is said to be dense if an index entry appears for every search-key value in the indexed file. Otherwise it is called a sparse index. Consider the follo...
0 0 votes
0 0 answers
387
387 views
In B tree if they asked for max or min no of keys then we will going to add all keys right But in B+ tree if they asked keys for like height 5 and ordr 4 then we will goi...