Monday, April 30, 2012 7:16 AM
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
Monday, April 30, 2012 7:22 AMAnswererData 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/
Monday, April 30, 2012 7:22 AM
MCITP BI Developer - MCTS SQL Server (http://bichopsuey.wordpress.com/)
Monday, April 30, 2012 7:23 AM
Please read this
Please mark answered if I've answered your question and vote for it as helpful to help other user's find a solution quicker
- Marked As Answer by DBA DEVELOPER Monday, April 30, 2012 7:26 AM
Monday, April 30, 2012 7:27 AMYou can also check MSDN for the index basics
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.