Re: PK vs Unique index

[Quoted] Hi Phil,

At the risk of stating the obvious, a unique index will allow NULL values...I'd only be guessing about performance..I'm just saying that you're comparing two different functionalities (one with unique/no nulls and one with unique only)..

It seems to me that it's more a question of what you require than a performance issue...

I hope this helps,

Steve

"Philip Morrow" <cracker_at_mymorrow.com> wrote in message news:kQW08.45721$_p.11054374_at_typhoon.tampabay.rr.com...
> Is there any performance difference is you use a PK constraint vs just
> creating a unique index. I know the PK will create the unique index as
> well, but is there a disadvantage to creating just a index and not a PK
> constraint
>
> Thanks
> Phil
>
>
Received on Tue Jan 15 2002 - 19:55:29 CET