0
Dense Index:
An index record appears for every search key value in file.
This record contains search key value and a pointer to the actual record.
Sparse Index:
Index records are created only for some of the records.
To locate a record, we find the index record with the largest search key value less than or equal to the search key value we are looking for.
We start at that record pointed to by the index record, and proceed along the pointers in the file (that is, sequentially) until we find the desired record.
-
-
(ref: http://sawaal.ibibo.com/computers-and-technology/difference-between-sparce-index-dence-index-773764.html)
Add your answer:
Earn +20 pts
What is the difference between value weighted index and equal weighted index?
Value weighted index is a market average such as Standard & Poor's 500 Index that takes into account the market value of each security rather than calculating a straight price average. An equal weighted index is a type of weighting that gives the same weight, or importance, to each stock in a portfolio or index fund. The difference is one gives individual value and other gives one value to all.
Defference between direct sequential and index sequential?
reduce the chance of false identification.----apex
Why fisher index is the ideal index?
becaused it is exact
Disadvantages of index number?
disadvantages of index numbers
How do you calculate machine capability index?
How to calculate machine price index?
Advantage and disadvantage of sparse index over the dence index?
Sparse advantage, less storage space required Dense advantage faster since each index key is directly linked to a record key
What is the index error in theodolite?
Half of the difference between the two positions is called the "index error".
Is there any difference between index and indicator?
yes there iis
What are the difference between Unicode and ASCII code?
describe the destination index
Why the refractive index of ice is lower than that of water?
The refractive index of a material is related to how light propagates through it. Ice has a lower refractive index than water because its molecular structure is less dense and more sparse compared to water. This difference in molecular arrangement affects how light interacts with the substance, leading to a lower refractive index in ice compared to water.
What is the difference between viscosity and viscosity index?
Viscosity is resistance to flow of oil Viscosity Index is a scale to measure viscosity
What is the difference between a glossary and index?
A glossary defines words, while the index tells what pages certain topics are on in the book.
Difference between Index File and Index Sequential file?
index file is organized with the help of any key as index number at rondomly but index sequencial file organized with the help of any index sequentialy rajesh patel
What is the difference between mutual funds and index funds?
Index funds are a type of mutual fund that invests in the stocks of a specific market index, attempting to maintain a value per unit that tracks that index.
What is the difference between an index one crime and an index two crime as measured in the Uniform Crime Reports of the FBI?
any type of crime
What is the difference between male and female body mass index?
There are boys and girls. They are different
What are the difference's between contour interval and index contour?
A contour interval is the vertical distance between contour lines on a topographic map, representing the change in elevation. An index contour is a heavier contour line that is labeled with the elevation value, to help users quickly identify key elevations on the map.
