INDEXING DATABASE

Question

Clustering index is always sparse?? comment with explanation...??

Answer 1

clustering index is the index which has a record for every search key value and the index appears in the order of records in the database..

sparse index is the index whose index is a subset of the search key value.and the index appears in the order of records in the database..

 

now there is case where in sparse index the subset of index=all search key values so you can say clustering index is sparse index but the reverse cant be said...

Comments

I have a doubt here...in clustering index we have index entries for every distinct value which is same as dense index..Why we considering it as sparse??