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, and this longer discussion.
2 of 3
Link to Usenet discussion including David Portas, Kalen Delaney, and Tibor Karaszi, among others.
Mike Sherrill 'Cat Recall'
- 10.9k
- 1
- 37
- 44
Catcall
- 10.9k
- 1
- 37
- 44