Sign in
 
Home20122008 R2200820052000LibraryForums
SQL Server >
> 
> 
How Indexes work on tables?

Answered How Indexes work on tables?

  • Monday, April 30, 2012 7:16 AM
     
     
    Sign In to Vote
    0

     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

     

All Replies

  • Monday, April 30, 2012 7:22 AM
    Answerer
     
     
    Sign In to Vote
    0
    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/

     
  • Monday, April 30, 2012 7:22 AM
     
     
    Sign In to Vote
    0

    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/)

     
  • Monday, April 30, 2012 7:23 AM
     
     Answered
    Sign In to Vote
    1

    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

    • Marked As Answer by DBA DEVELOPER Monday, April 30, 2012 7:26 AM
    •  
     
  • Monday, April 30, 2012 7:27 AM
     
     
    Sign In to Vote
    1
    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.