[dba-SQLServer] Performance of a unique index

The fastest index is the clustered index.

At 09:07 AM 11/13/2007, you wrote:
>Date: Tue, 13 Nov 2007 06:29:23 -0500
>From: "jwcolby" <jwcolby at colbyconsulting.com>
>Subject: [dba-SQLServer] Performance of a unique index
>To: <dba-sqlserver at databaseadvisors.com>
>Message-ID: <00d801c825e8$715c8bb0$6c7aa8c0 at M90>
>Content-Type: text/plain;       charset="us-ascii"
>
>Are there any performance implications for a unique index, pro or con?  I
>have tables where no data is added after the tables are set up.  Are unique
>indexes faster than non-unique?  Are they slower?  No difference?  I do not
>need the capability to enforce uniqueness since the tables are completely
>static so I want the fastest index.
>
>John W. Colby