Re: Unique contraints vs. Unique indexes

From: Robert Fazio <rfazio_at_home.com.nospam>
Date: Fri, 10 Aug 2001 22:00:54 GMT
Message-ID: <qQYc7.91105$EP6.22113665@news1.rdc2.pa.home.com>

Do you really mean non_unique? A PK is a PK. You either want all of the fields at creation and you want them to be unique or you don't.

The only difference between a UK and a PK is that UK's don't have to have all fields supplied (i.e. Some can be null).

--
Robert Fazio
Senior Technical Analyst
dbabob_at_yahoo.com

"James Williams" <techsup_at_mindspring.com> wrote in message
news:3b744034.170930734_at_nntp.mindspring.com...


> I am about to build a data warehouse that will eventually be 1 TB.

>

>

> A PK's are going to have non_unique indexes and so that they can be

> deferrable.

>

>

> What are the heavy hitters opinions on this?

Received on Fri Aug 10 2001 - 17:00:54 CDT