6 ms·
>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 syste
by dspillett 11y 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-defaults-primary-key-clustering-key http://use-the-index-luke.com/blog/2014-01/unreasonable-defa... as a good run down of the whys and wherefores of clustered indexes.