When SQL Server Nonclustered Indexes Are Faster Than Clustered Indexes
Posted
on SQL Server Central
See other posts from SQL Server Central
Published on Thu, 10 Oct 2013 06:00:00 UT
Indexed on
2013/10/18
10:08 UTC
Read the original article
Hit count: 317
Filed under:
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? Check out this tip to learn more.
 | Deployment Manager 2 is now free! The new version includes tons of new features and we've launched a completely free Starter Edition! Get Deployment Manager here |
© SQL Server Central or respective owner
