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

Articles with tag non-clusterd index Rss

Search for any content tagged non-clusterd index

   Items 1 to 2 of 2   

Performance Myths : Clustered vs. Non-Clustered Indexes

Aaron Bertrand kicks off his "Performance Myths" series, showing a "redundant" non-clustered index outperforming the clustered index with the same key.  Read more...
By Additional Articles 2017/04/17 | Source: SQLPerformance.com | Category: clustered index
Rating: (not yet rated)  Rate this |   Briefcase | 5,167 reads

Covering Index using Included Columns

This article from Josef Richberg details the benefits of included columns for use in creating a covering index to improve performance.   Read more...
By Josef Richberg 2010/02/11 | Source: SQLServerCentral.com | Category: included columns
Rating: |  Discuss |   Briefcase | 12,493 reads
   Items 1 to 2 of 2