Difference between primary index and secondary index
Answers
Answered by
11
Primary Indexi) It is an ordered file whose records are of fixed length with two fields.
ii) Only based on the primary key.
iii) The total number of entries in the index is the same as the number of disk blocks in the ordered data file.
iv) Primary index is a king of nondense (sparse) index.
v) There may be at most one primary index for a file.
vi) Needs less storage space. Secondary indexi) It provides a secondary means of accessing a file for which some primary access already exists.
ii) May be based on candidate key or secondary key.
iii) It has a large number entries due to duplication.
iv) Secondary index is a kind of dense index.
v) There may be more than one secondary indexes for the same file.
vi) Needs more storage space and longer search time.
ii) Only based on the primary key.
iii) The total number of entries in the index is the same as the number of disk blocks in the ordered data file.
iv) Primary index is a king of nondense (sparse) index.
v) There may be at most one primary index for a file.
vi) Needs less storage space. Secondary indexi) It provides a secondary means of accessing a file for which some primary access already exists.
ii) May be based on candidate key or secondary key.
iii) It has a large number entries due to duplication.
iv) Secondary index is a kind of dense index.
v) There may be more than one secondary indexes for the same file.
vi) Needs more storage space and longer search time.
sowmy635:
plz mark it as brainlist
Similar questions