Non or Clustered index is the question

• BuilderBits

  SSCertifiable

  Points: 6071

  More actions

  January 26, 2007 at 9:23 am

  #69582

  After pulling my finger nails out one at a time just to feel relief from trying to figure out non and clustered indexes; i thought it was time to start asking questions..

  Here is what i need to get cleared up..

  If an clustered index is located in the leaf node; and the clustered index and the datapages are both in the leaf node stored in the order dictated by the index......How is it that in a non clustered index that they are stored in the leaf node and them point to the datapages..

  How can a non clustered index be in the leaf node (with the clustered indexes) and then point to the datapages if they reside in the same as with the clustered indexes (I THOUGHT CLUSTERED INDEXES ARE STORED INDEX AND DATA TOGETHER IN THE DATA PAGE)how can the non clustered indexes be in the node if they are not in the same node as the data pages??

  Erik

  Dam again!

• BuilderBits

  SSCertifiable

  Points: 6071

  More actions

  January 26, 2007 at 9:31 am

  #685878

  Never mind i see where y'all have given me really good answers of in my previous post..

  http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=145&messageid=338489

  I did not get these alters for some reason;

  erik

  Dam again!