Explain why a secondary, unclustered index must be dense.

What will be an ideal response?

A dense index is an index whose entries are in 1-1 correspondence with the corresponding records in the data ?le. A secondary, unclustered index must be dense since data records are ordered di?erently from index entries and hence there is no way to ?nd a record if no index entry refers to it.