[dba-SQLServer] Performance of a unique index

Arthur Fuller fuller.artful at gmail.com
Tue Nov 13 09:43:07 CST 2007


This is correct, and is due to the fact that creating a clustered index
physically resorts the table into the sequence specified by the key.
Although, JC, be aware that this is going to take a while, given the size of
your table.

A.

On 11/13/07, Robert L. Stewart <robert at webedb.com> wrote:
>
> The fastest index is the clustered index.
>



More information about the dba-SQLServer mailing list