I need to know how the primary index is classified as a sparse index?
The sparse index as described by some aticles and books has index entries for only some of the search values and has a fewer entries than the number of records in the file. When you make the primary key you choose a column that will include a unique value for each record entry. So when you make and index on that key there must an index entry for each unique value.
So how the primary index is classified as a sparse index that has only some of entries?!!!