Re: Preferred method in creating primary key

Norman Dunbar schrieb:

> Hi Jack,
>
> my favourite method is this :
>
> create table blah (.....)
> create index blah_pk on blah (...)
> alter table blah add constraint blah_pk primary key (...) deferrable
> initially immediate;
>

What is the advantage of first specifying the index, and then defining the primary key?

I thought Oracle will create a unique index on the table anyway when I define a primary key...

Thomas Received on Wed Aug 13 2003 - 07:12:52 CDT