I am trying to understand some fundamentals in SQL server, I read that indexes (Set of pages) are arranged in B-Tree structure...and if it is a clustered index then we find the row of data at the leaf node or else a pointer to the data in case of a non-clustered
Now my doubt is clustered index have the row at leaf level that means the entire table is available at the leaf nodes of the clustered index...then where are the non-clustered indexes leaf nodes pointing to
1) Are they pointing to the clustered indexes leaf node, as the rows are there.
2) If they are pointing to some other place then is this not duplicating the records (I do not think this is the case and am understanding things wrong..)
Thanks in advance..
View Complete Post