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_at_lc03.rz.uni-jena.de>
>
> This is implementation dependent.
Date: Wed, 15 Feb 2006 15:33:36 +0100
Message-ID: <dsve40$kor$1_at_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 GermanyReceived on Wed Feb 15 2006 - 15:33:36 CET