Tuesday 16 April 2013

SQL Server : Index at a glance

In the last ten posts, we have discussed in details about the SQL server index and its storage structure. In this post I will consolidate all the ten post for easy reference.

What is index ?
In the first post, we have discussed about index in general. We tried to understand the clustered  index non clustered index and key lookup  with a sample from real life. Read More

What is heap table?
A table with out clustered index is called heap table. Data in heap table are not stored in any specific order.To understand more about the heap structure Read More

B tree structure of Clustered index

A table with clustered index is called Clustered table.Clustered index stores the actual data in the order of clustering key using a b tree structure.A table can have only one clustered index. To understand more about clustered index table storage and access pattern, read this article 

B tree structure of a non clustered index on clustered table
We can have many non clustered index on a table.To understand about the non clustered index storage structure and the way SQL server use the non clustered index, read here

B tree structure of a non clustered index on heap  table
How non clustered index works on a heap table,Read More

Design Consideration of clustered index key
What you should consider while deciding clustered index key. What will happen if you defined a clustered index on a non unique column ? Read the article Design Consideration of Clustered index.

Overhead on non clustered index on a non unique column 
You ever thought about difference in storage structure non clustered index while defining on non unique column. This post will give you more insight.

How to get rid of key lookup operation ? 
Book mark look up or Key Look up operation is very common in execution plan. How to get rid of that . Learn about covering index and included column in this post

Filtered index with its limitation 
How to define index on part of the table data ? How to define complex unique constraint on a table. How to improve performance of a query which work on small chunk of table data. Filtered index is the new way to solve the issue. Read more

Real time sample of the importance of the index key column order
The column order in the index is very important. It define the way data stored.The data access patter will play a major role in deciding the key column order. Shared some thoughts on this article 

If you liked this post, do like my page on FaceBook


  1. Thanks for the articles. It seems to me that with them it will be easier for me to work with my site and the server itself

  2. Obat Penggugur Kandungan Janin Jual Obat Aborsi Alsi Jual Obat Aborsi Penggugur Kandungan Jual Obat Aborsi Cytotec


  3. مكافحة حشرات بالخبر مكافحة حشرات بالخبر
    مكافحة حشرات بمكة مكافحة حشرات بمكة
    مكافحة حشرات بالمدينة المنورة مكافحة حشرات بالمدينة المنورة
    مكافحة حشرات بالدمام مكافحة حشرات بالدمام
    مكافحة حشرات بالاحساء مكافحة حشرات بالاحساء

  4. قد اسسنا شركة مكافحة الصراصير بجدة توفر إليك خدمة رش مبيدات بجدة اللازمة في التخلص من الصراصير القاتلة والتي تسبب إليك الأمراض والإصابة بالكثير من الفيروسات وتنقل إليك العدوى والجراثيم إلى الأطعمة الخاصة بك أو من خلال الادوات التي تستخدمها بشكل شخصي وبالتالي إذا كنت ترغب في حل نهائي لهذه المشكلة فأليك الأن شركة مكافحة البق بجدة تعمل على تخلصك من بق الفراش بشكل نهائي وفعال وبأقل الأسعار ولديك ايضا شركة مكافحة النمل الابيض بجدة التي تقضي على الأرضة وحشرات الخشب التي تدمر المنازل معنا شركة مكافحة حشرات انت في امان

  5. Thank you for a little bit of lacquer. I really liked the article and in return, I would want to share with the following website webstagram

  6. Great post, you have pointed out some fantastic points , I likewise think this s a very wonderful website 먹튀검증업체

  7. You completed certain reliable points there. I did a search on the subject and found nearly all persons will agree with your blog. 메이저놀이터

  8. Positive site, where did u come up with the information on this posting?I바람프리서버

    have read a few of the articles on your website now, and I really like your style. Thanks a million and please keep up the effective work.

  9. I blog frequently and I really thank you for your content. This article has truly peaked my interest 토토사이트 I'm going to book mark your blog and keep checking for new information about once a week. I opted in for your RSS feed too.

  10. I also benefit from learning the assessments, but learn that alot of people ought to stay on essay to try and add worth in the direction of the authentic weblog release. 온라인슬롯

  11. You uploaded a fantastic post. I was extremely touched after I saw your writing, and also I actually suched as the tale of what I was searching for due to the fact that it included whatever. I'm so interested concerning exactly how you thought about this info and also exactly how you located it. Take a look at my writing and also let me recognize. 바카라사이트

  12. I figure this article can be enhanced a tad. There are a couple of things that are dangerous here, and if you somehow managed to change these things, this article could wind up a standout amongst your best ones. I have a few thoughts with respect to how you can change these things. 먹튀검증업체

  13. It's really great. Thank you for providing a quality article. There is something you might be interested in. Do you know 먹튀검증? If you have more questions, please come to my site and check it out!

  14. I finally found what I was looking for! I'm so happy. 우리카지노

  15. Appreciation to my father who stated to me on the topic of this weblog, this webpage is really amazing. 토토

  16. Easily, the article is actually the best topic on this registry related issue. I fit in with your conclusions and will eagerly look forward to your next updates. 슬롯머신사이트

  17. This article is a must-read for any SQL Server developer or DBA. it's a topic that can be overwhelming, but you broke it down in a way that's easy to grasp. best seo services in gwalior