in Databases
1,855 views
3 votes
3 votes

Secondary key over key is dense and secondary key over non key is sparse

is it correct ?

i think it should be

Secondary key over non key is dense and secondary key over key is sparse

in Databases
1.9k views

4 Comments

2
2
tx for sharing
1
1
bro secondary index on primary key can never fail

THis is wrong reference

primary key can do anything.

how can he say it will fail?
0
0

1 Answer

2 votes
2 votes

Secondary index over key build based on unordered field so that it must be dense index,

but secondary index over non key is mostly sparse index.