201 views

1 Answer

0 votes
0 votes
primary index :- file is ordered by key and use sparse index because of file is ordered

clustered index :- file is ordered by non-key and use sparse index because of file is ordered

secondary index :- file is un-ordered by non-key/candidate key and use dense index because of file is ordered

 

according to your question it is clustered index

Related questions

0 votes
0 votes
0 answers
1
3 votes
3 votes
1 answer
2
Na462 asked Jan 26, 2019
1,815 views
0 votes
0 votes
0 answers
3
Parimal Paritosh asked Aug 30, 2018
580 views
Which tree has more number of levels for 'n' nodes - B tree or B+ tree? What's the reason behind it?
2 votes
2 votes
1 answer
4
Na462 asked Jun 29, 2018
646 views
Here the indexing is done on ordered field so which to use Dense or Sparse because both can be done here ?