|
|
|
|
|
|
by dspillett
3725 days ago
|
|
|
>How does the sort order in the index have anything to do with the arrangement of the table? If you have a clustered index based upon that column (and in systems that support this it is common for the primary key to be the clustered index for the table) then the physical layout of the data will follow this column. See http://use-the-index-luke.com/blog/2014-01/unreasonable-defa... as a good run down of the whys and wherefores of clustered indexes. |
|
|