A lot of people believe that a clustered index guarantees a sort order on output. But that's not what it does; it guarantees a storage order on disk.
See, for example, this blog post, a follow-up, and this longer discussion.
Catcall
- 10.9k
- 1
- 37
- 44