Scott Rankin (1/21/2013)
So you are getting way down into the heart of SQL Server internals here.
Not that deep really
But, if I understand it correctly, the difference between logical and physical at this point is way beyond what the originator of the thread was worried about.
Sure, but the 'clustered indexes are physically ordered by their keys' can result in some nasty misunderstandings of how indexes work and why. Classic one I see is people claiming that because the clustered index is physically ordered by the key, it's faster for range searches (in fact BoL claims that), whereas actually nonclustered indexes are faster for range searches.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability