Skip to main content
Database Administrators

Return to Answer

added 111 characters in body
Source Link
Aaron Bertrand
Aaron Bertrand
  • 181.5k
  • 28
  • 402
  • 619

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 postthis blog post, a follow-up, and this longer discussion.

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.

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.

Link to Usenet discussion including David Portas, Kalen Delaney, and Tibor Karaszi, among others.
Source Link
Mike Sherrill 'Cat Recall'
Mike Sherrill 'Cat Recall'
  • 10.9k
  • 1
  • 37
  • 44

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.

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 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.

Post Migrated Here from stackoverflow.com (revisions)
Source Link
Mike Sherrill 'Cat Recall'
Mike Sherrill 'Cat Recall'
  • 10.9k
  • 1
  • 37
  • 44

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.