rjv_rnjn (5/6/2010)
I re-read the MSDN article as to why I thought it's physical order of arrangement.MSDN: http://msdn.microsoft.com/en-us/library/aa933131(SQL.80).aspx
Because the clustered index dictates the physical storage order of the data in the table
And the option was:
Rows in a table are PHYSICALLY stored in the clustered index order
I am not sure I quite understand the difference.
The part in MSDN about rows being physically stored in the clustered index order is what threw me off as well. I think Hugo's explanation makes sense though.