SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Articles with tag Non-Clustered Index Rss

Search for any content tagged non-clustered index

   Items 1 to 2 of 2   

When SQL Server Nonclustered Indexes Are Faster Than Clustered Indexes

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.  Read more...
By Additional Articles 2013/10/10 | Source: MSSQLTips.com | Category: clustered index
Rating:  Rate this |   Briefcase | 6,150 reads

Tables and Clustered Indexes Part 2

A table does not so much 'have' a clustered index as a table 'is' a clustered index.  Read more...
By Hakim Ali 2013/07/22 | Source: SQLServerCentral.com | Category: clustered index
Rating: |  Discuss |   Briefcase | 6,435 reads
   Items 1 to 2 of 2