in Databases
813 views
0 votes
0 votes

among primary index, secondary index, clustered index which index are dense or sparse or both?

in Databases
813 views

1 comment

in any indexing dense /sparsh is differ at only 1st level after that it will be sparsh indexing to the root.(for any kind of indexing).
3
3

1 Answer

2 votes
2 votes
when data is unordered we use dense indexing to point to every record in the file. when data is ordered we point to every block containing records of the data file.in sparse we dont point to every data record because there is no need since the data is ordered. so in  now primary indexing based on candidate key->ordered->sparse,clustered index->based on key or non key but similar type of attribute  clusters or group and ordered->sparse..but secondary index->based on unordered data->dense.

Related questions