nonclustered Covering index will usually provide the optimum performance of a query

Designers of database systems will often assume that the use of a clustered index is always the best approach.

However the nonclustered Covering index will usually provide the optimum performance of a query.

https://www.simple-talk.com/sql/learn-sql-server/using-covering-indexes-to-improve-query-performance/

This entry was posted in SQL Server and tagged . Bookmark the permalink.