Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tags Indexing, 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 2015/10/09 (first published: 2013/08/12) | Source: SQLServerCentral.com | Category: covering index
Rating: |  Discuss |   Briefcase | 14,019 reads

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 2015/10/09 (first published: 2013/08/12) | Source: SQLServerCentral.com | Category: covering index
Rating: |  Discuss |   Briefcase | 14,019 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,297 reads
   Items 1 to 3 of 3   
 
Tags
execution plans (1)    
index seek (1)