Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tag covering index Rss

   Items 1 to 3 of 3   
 

How efficient is your covered index?

Observing an index seek utilizing a composite index within SQL execution plan might be more than meets the eye – you should look again.  Read more...
By Simon Liew 2013/08/12 | Source: SQLServerCentral.com | Category: covering index
Rating: |  Discuss |   Briefcase | 8,252 reads

Finding all Columns of an Index

This script helps to find all columns of an index on a table. Include columns covered (include)  Read more...
By Augusto Alfonso 2011/06/17 | Source: SQLServerCentral.com | Category: indexing
Rating: |  Discuss |   Briefcase | 1,272 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,134 reads
   Items 1 to 3 of 3   
 
Tags
indexing (2)    
execution plans (1)    
included columns (1)    
index seek (1)    
non-clusterd index (1)