Re: newbies index question?

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Sun, 25 Feb 2001 19:30:25 +0100
Message-ID: <8oji9tcnugehe69kcokqnevcbf4cf2l2qu@4ax.com>

On Sun, 25 Feb 2001 19:11:26 +0100, Julien Reynier <julien.reynier_at_free.fr> wrote:

>Hi,
>
>I would like to know if I have to create index before add primary key
>constraint or not? In others words should I create my own indexes or
>should I use auto created indexes generated during primary key
>constraint setting?
>
>Thanks...

The latter
add constraint <constraint name> primary key (<columns>) using index tablespace <your tablespace> etc

Hth,

Sybrand Bakker, Oracle DBA Received on Sun Feb 25 2001 - 12:30:25 CST