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

Question

Quizplus · Accepted Answer

A clustered index physically reorders the rows in a table based on the index columns, making data retrieval faster because the data is stored in a sorted order. Nonclustered indexes are still useful for improving performance, but they require an additional lookup to the clustered index or table data to retrieve the actual values. Unique and baseline indexes do not necessarily provide any advantage for data retrieval.

Which Type of Index in SQL Server Is Faster for Data