e-ghetto (7/3/2012)
Clustered indexes define the logical order of the table
I would say: Clustered indexes define the physical order of the table. Am I right?
No. They define the logical order only.
If a clustered index defined and guaranteed the physical order of data on disk, then clustered indexes would never become fragmented (as fragmentation is defined as the difference between physical and logical order). Is that the case?
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