Re: Indexes and Constraints
From: Gabriel Radu <gabriel.radu_at_znt.de>
Date: 13 Jun 2001 07:43:28 -0700
Message-ID: <d9d350a7.0106130643.24adba4b_at_posting.google.com>
Date: 13 Jun 2001 07:43:28 -0700
Message-ID: <d9d350a7.0106130643.24adba4b_at_posting.google.com>
Oracle automatically creates an index on columns on which you defined a primary key.So, you don't need to do this explicitly.
"Bruce Ostrover" <bruceo_at_bellatlantic.net> wrote in message news:<y37V6.13687$nf.5160629_at_typhoon1.ba-dsg.net>...
> All,
>
> If you have a constraint defined for a table (like the one below), and we
> are using Oracle 8.15 .. then does Oracle create an index for you, or do you
> need to create one explicitly
>
> constraint PK_TAXCALC primary key (TAXCALCID),
>
> Regards,
>
> Bruce
Received on Wed Jun 13 2001 - 16:43:28 CEST