Community

When SQL Server Nonclustered Indexes Are Faster Than Clustered Indexes

(Tim Wiseman) SQL Server Clustered indexes can have enormous implications for performance of operations on a table. But are there times when a SQL Server non-clustered index would perform better than a clustered index for the same operation? Are there any trade-offs to consider?

Read More - Register for Free Membership