• Thanks Gail, I learned something new again.

    I thought that because a clustered index is always ordered, a scan would always be the same. I'm glad I didn't get this question on my exam. But now I know better 😉

    ** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **