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 Databases databases indexing + – Mayank Gupta 3 asked Mar 4, 2018 Mayank Gupta 3 637 views answer comment Share Follow See 1 comment See all 1 1 comment reply yogi_p commented Mar 4, 2018 reply Follow Share I think Both are Correct a) Clustered Index is in the same way that actual rows of table are stored in sorted order based on some key value, hence it is useful for range queries. b) For clustered index we can even 1 entry for each data block therefore its quite sparse and less expensive. 0 votes 0 votes Please log in or register to add a comment.
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. Sanandan answered Aug 24, 2020 Sanandan comment Share Follow See all 0 reply Please log in or register to add a comment.