in

SQLServerCentral.com

The largest free SQL Server community.

Browse by Tags

  • 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. When doing so SQL Server is smart enough to realize...
    Posted to Ken Kaufman (Weblog) by Ken Kaufman on 06-06-2008
  • 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 add to the non-clustered index without having to worry...
    Posted to Ken Kaufman (Weblog) by Ken Kaufman on 06-05-2008
Page 1 of 1 (2 items)
Copyright Red Gate Software
Powered by Community Server (Commercial Edition), by Telligent Systems