"Darren New" <dne### [at] sanrrcom> wrote in message
news:4891e365$1@news.povray.org...
>
> > There's a fairly decent diagram here - :
> > http://msdn.microsoft.com/en-us/library/ms177443.aspx
>
> That's a fairly good picture of a B-tree. :-)

Yup. Look at that and the one for the nonclustered indexes (link's at the
bottom of the page) and compare what's at the leaf level

> > Does thet help at all, or have I just muddied the water more?
>
> It helps. I guess I just wasn't thinking it through. Thanks for
> clarifying that.

Pleasure. There are a lot  of full time SQL Server people who have little to
no clue what a clustered index is.

Post a reply to this message