Is a composite index key always part of a covering index?

Options
- Yes
- No

CORRECT ANSWER : No

Discussion Board
Composite index

No, the composite index key is not part of a covering index. A composite index is just an index defined over more than one column. It may or may not be a covering index as well. A covering index is an index that "covers" a query. That is it supplies all information for the query so that SQL Server does not have to touch the base tables.

Prajakta Pandit 03-6-2017 07:43 AM

Write your comments


Enter the code shown above:

(Note: If you cannot read the numbers in the above image, reload the page to generate a new one.)


Related Content

Advertisement
 
▲