[dba-SQLServer] Are indexes unique

Arthur Fuller fuller.artful at gmail.com
Mon Aug 29 12:12:41 CDT 2011

Unique only counts on the specified fields.


On Mon, Aug 29, 2011 at 12:32 PM, jwcolby <jwcolby at colbyconsulting.com>wrote:

> If I have a clustered index on my PK (autoincrement int) and that is used
> in all indexes without specififying that it be used (my understanding) does
> that mean that every index is by definition unique?  Do I need to check the
> unique box when creating the index?
> Or does "unique" only count on the actual fields specified in the index?

More information about the dba-SQLServer mailing list