Browse by Tags

• Index
• Performance
• SQL Server Query Performance

• Leveraging Clustered Indexes in a Covered Index

  In my last blog I talked about covering indexes. In doing so I slightly touched up non-clustered indexes containing a pointer to the clustered index of the table. There are often times when you want to cover a portion of the a composite clustered index... Posted Jun 06 2008, 06:28 PM by Ken Kaufman with | with no comments Filed under: Performance, Index, Covered Indexes

• Covering Indexes

  Covering an index allow you to use a subset of data in an underlying table to answer queries without having to go to the underlying table, whether the underlying table is based on a clustered index or a heap. Using the “include” feature allows you to... Posted Jun 05 2008, 04:26 PM by Ken Kaufman with | with no comments Filed under: SQL Server Query Performance, Index, Covered Indexes