The Gateway to Computer Science Excellence
0 votes

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

in Databases by (431 points) | 122 views
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).

1 Answer

0 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 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.
by (287 points)
Quick search syntax
tags tag:apple
author user:martin
title title:apple
content content:apple
exclude -tag:apple
force match +apple
views views:100
score score:10
answers answers:2
is accepted isaccepted:true
is closed isclosed:true
50,737 questions
57,306 answers
105,012 users