In this article, we look at why SQL Server may not use a non-clustered index over the clustered index and what you can do to improve performance.
The post Improve Query Performance when SQL Server Ignores Nonclustered Index appeared first on SQLServerCentral.
