Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
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 | 5,637 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,358 reads
   Items 1 to 2 of 2