sonveer .If the file records are physically ordered on a non-key field such as name (which does not have a distinct value for each record) then in that case clustered index is used.
And the index is maintained for every distinct value of that clustering field. So it is not purely dense or purely sparse, right?
for every distinct value
@Arjun sir, i haven't got my consignment. the ...
Nice to see your plenty ...
For those who knows only about ...