Which type of index in SQL Server is faster for data retrieval?
A)Clustered
B)Nonclustered
C)Baseline
D)There is no advantage to any particular index for data retrieval,only for data updating.

Question

Quizplus · Accepted Answer

Clustered indexes physically sort the data on disk, making it faster for data retrieval. Nonclustered indexes create a separate structure that maps to the data, which can cause additional overhead for data retrieval. Therefore, clustered indexes are generally faster for data retrieval.

Which Type of Index in SQL Server Is Faster for Data