637 views
1 votes
1 votes
which of the statements are correct?

A a clustered index offers much better performance than unclustered index for range queries

B a clustered index istypically less expensive to manage than unclustered index

1 Answer

1 votes
1 votes
Both are correct

a)as clustered index is sorted.

b) Clustered index is sparse as it consists of unique key values.

Related questions

2 votes
2 votes
1 answer
1
vnc asked Jan 13, 2017
1,410 views
Let T be a B-tree of order m and height h. if n is the number of key elements in T then the maximum value of n is(m-1)h-1(m-1)h-1+1Mh-1Mh+1+1
0 votes
0 votes
1 answer
2
2 votes
2 votes
0 answers
3
set2018 asked Oct 21, 2017
325 views