814 views
0 votes
0 votes

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

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

0 votes
0 votes
0 answers
1
2 votes
2 votes
1 answer
3
3 votes
3 votes
1 answer
4
Na462 asked Jan 26, 2019
1,812 views