Creation of index for primary key
From: Michael P. Stein <mstein_at_access3.digex.net>
Date: 26 Sep 1994 16:54:09 -0400
Message-ID: <367cdh$40g_at_access3.digex.net>
Date: 26 Sep 1994 16:54:09 -0400
Message-ID: <367cdh$40g_at_access3.digex.net>
In article <35i0lj$565_at_crocus.csv.warwick.ac.uk>,
Hank Robinson <cudau_at_csv.warwick.ac.uk> wrote:
>Strictly speaking, you don't actually need to create a (unique) index on
>your column Company_code, as identifying it explicitly as the Primary Key
>will create a unique index on that column for you. I think this is even
>true for Oracle version 6, wherein a lot of data integrity was not implemented.
This is *not* true for V6 - no unique index is created as the result of a PRIMARY KEY or UNIQUE constraint.
-- Mike Stein The above represents the Absolute Truth. POB 10420 Therefore it cannot possibly be the official Arlington, VA 22210 position of my employer.Received on Mon Sep 26 1994 - 21:54:09 CET