How Indexes work on tables?

Question

 If i create one clustered index on a table and again non-clustered index on the same table then how does the indexes work?

Thanks In Advance

Answer 1

Data is stored on the table with indexes in B-TREE structure.. There is no principal difference between NCI B-TREE and CI B-TREE , but one important difference is that leaf level of CI contains actual data , and leaf level of NCI contains pointers to the data pages (where data is stored)

---

Best Regards, Uri Dimant SQL Server MVP http://dimantdatabasesolutions.blogspot.com/ http://sqlblog.com/blogs/uri_dimant/

Answer 2

http://www.mssqlcity.com/FAQ/General/clustered_vs_nonclustered_indexes.htm

http://en.wikipedia.org/wiki/Database_index

---

MCITP BI Developer - MCTS SQL Server (http://bichopsuey.wordpress.com/)

Answer 3

Please read this

http://www.simple-talk.com/sql/database-administration/brads-sure-guide-to-indexes/

vt

---

Please mark answered if I've answered your question and vote for it as helpful to help other user's find a solution quicker

Answer 4

You can also check MSDN for the index basics
http://msdn.microsoft.com/en-us/library/ms177443.aspx
http://msdn.microsoft.com/en-us/library/ms177484.aspx

---

Marek Chmel, WBI Systems (MCTS, MCITP, MCT, CCNA)
Please Mark As Answer if my post solves your problem or Vote As Helpful if a post has been helpful for you.