kapil_kk (7/22/2013)
Yes you are right but user PRR asked a scenario only for clustered index and if a clustered index is used then it will reorder of the data in physical order...
You're confusing the way the data is stored with the way it's returned. As Hugo explained, they're not guaranteed to be the same.
John
Edit - corrected typo.