Re: Do I need a PK on a join table?

From: Knut Stolze <stolze_at_de.ibm.com>
Date: Wed, 15 Feb 2006 15:33:36 +0100
Message-ID: <dsve40$kor$1@lc03.rz.uni-jena.de>

David Cressey wrote:

>
> "Knut Stolze" <stolze_at_de.ibm.com> wrote in message
> news:dsukp9$bbs$1_at_lc03.rz.uni-jena.de...
>
>

>> > If you have a strong argument for wanting no index, declare a
>> > uniqueness constraint.
>>
>> Which will be enforced by a unique index...

>
> This is implementation dependent.

Of course. The complete index-stuff is implementation-dependent/defined. But we're talking about DB2 here.

-- 
Knut Stolze
DB2 Information Integration Development
IBM Germany

Received on Wed Feb 15 2006 - 08:33:36 CST