answersLogoWhite

0


Best Answer

Sparse advantage, less storage space required

Dense advantage faster since each index key is directly linked to a record key

User Avatar

Wiki User

11y ago
This answer is:
User Avatar

Add your answer:

Earn +20 pts
Q: Advantage and disadvantage of sparse index over the dence index?
Write your answer...
Submit
Still have questions?
magnify glass
imp
Related questions

Outline one advantage and one disadvantage of using Human Development Index figures to measure standards of living?

one disadvantage of using human development index.


What is difference between sparse index and dense index?

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)


What are the advantages and disadvantages of index numbers?

Advantages of index numbers include easy comparison of data over time or between different categories, ability to simplify complex data into a single number, and usefulness in tracking trends. Disadvantages may include difficulty in choosing an appropriate base year, sensitivity to outliers, and potential for misinterpretation if not used correctly.


Advantage of graded index fiber over step index fiber?

A graded index multimode fiber will transmit 800 modes, and has a varying refractive index. A step index multimode will transmit 228 modes.


Why do baseball players remove a finger from their glove and extend it outside?

That is a personal preference and done mainly for comfort. There is no advantage nor disadvantage in doing it .... some players just feel more comfortable with the finger outside the glove. The index finger is closest to the pocket of the glove so you get more padding by having it outside the finger of the glove.


Advantage and disadvantage of Profitability index PI?

Disadvantages of Profitability Index are:-Only used for divisible projectsstrategic value of projects are not considered.( only figures are dealt with not long term not short termlimited use when protect have differing cash flow pattern. ( only limited to investment with major cash at the beginning)absolute NPV vale is ignored, smaller projects receive more favourable treatment ( the equation treats all project as equally important.R.ogunleye university of Herfordshire (UK)


How the index of the DBMS is organized and works?

A database index is a data structure that improves the speed of data retrieval operations in DBMS. An index can be created using one or more columns of a database table, providing the basis for both rapid random lookups and efficient access of ordered records. Most indexes use a B-tree structure. A B-tree is a tree data structure that keeps data sorted and allows searches, sequential access, insertions, and deletions in logarithmic amortized time. The B-tree is a generalization of a binary search tree. The B-tree is optimized for systems that read and write large blocks of data. There are several index types out there: Bitmap index Dense index Sparse index Reverse index Etc...


How is sparse matrix stored in the memory of a computer?

A sparse matrix contains many (often mostly) zero entries. The basic idea when storing sparse matrices is to only store the non-zero entries as opposed to storing all entries. Depending on the number and distribution of the non-zero entries, different data structures can be used and yield huge savings in memory when compared to a naïve approach. One example of such a sparse matrix format is the (old) Yale Sparse Matrix Format [1]. It stores an initial sparse N×N matrix M in row form using three arrays, A, IA, JA. NZ denotes the number of nonzero entries in matrix M. The array Athen is of length NZ and holds all nonzero entries of M. The array IA stores at IA(i) the position of the first element of row i in the sparse array A. The length of row i is determined by IA(i+1) - IA(i). Therefore IA needs to be of length N + 1. In array JA, the column index of the element A(j) is stored. JA is of length NZ. Another possibility is to use quadtrees


What the uses of index number in index index?

uses of index


What is the major advantage of a hash table?

The major advantage of a hash table is its speed. Because the hash function is to take a range of key values and transform them into index values in such a way that the key values are distributed randomly across all the indices of a hash table.


What is the possessive of index?

The possessive form of "index" is "index's." For example, "the index's values are displayed in alphabetical order."


What is sensitive index in sensex?

Sensitive Index is a criticle Index.