Unique Index Vs Primary Index in SQL Server 2000

microsoft.public.sqlserver.programming

4 Nov 2005 8:39 PM

harish

Hi

Will there be any performance difference if a primary index is created
instead of a unique index or vice-versa in SQL Server 2000.
All the columns are non-nullable.

Thanks
harish

4 Nov 2005 11:09 PM

Erland Sommarskog

harish (harish.prabh***@gmail.com) writes:

> Will there be any performance difference if a primary index is created
> instead of a unique index or vice-versa in SQL Server 2000.

No.

Use constraints to denote logical properties of the table, and indexes
for things that need better performance.

--
Erland Sommarskog, SQL Server MVP, esq***@sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp