0
kicks
Covering Index in SQL Server
There is a new type of index called “Covering Index” in SQL Server 2005. This feature gives us the option to put a Non-indexed column to the leaf node of the indexed column. You can't create Covering Index for Clustered Index. This is also known as Included Columns.If I am confusing lets look at the below example.