February 20, 2006 at 8:43 am
Does anybody have the definition\differences between these three types of index methods?
February 20, 2006 at 3:05 pm
A covering index refers to a non-clustered index that is defined across all columns (in 2005 you can now have Included Columns) that a given query is after. This means that for that query, all the data that it needs in contained in the leaf level of the non-clustered index so there is no need to do bookmark lookups to the clustered index (assuming there is one).
Compound indexes and Composite indexes are synonymous, they refer to an index that has more than one column as its key.
/*****************
If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek
*****************/
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply