Covering Index in SQL Server (dotnetvj.com)

submitted by KadiyalavjKadiyalavj(580) 3 years ago

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.

add a comment |category: |Views: 8

tags: another

new Add a live kick counter to your blog >> liveImage

You can even customize the image by choosing your own colors, and then clicking the button below to update the preview and the html code:

  • "Kick It" text
  • "Kick It" background
  • kick count text
  • kick count background
  • border

Simply copy and paste this HTML into your blog post.


Users who kicked this story:
Comments:

No comments so far

information Login or create an account to comment on this story