Re: Unique and non unique index

Hi, Morgan
 You are right . we can also create a non unique index and then add primary key using the index.
eg=>
create table em as select * from emp;

create index em_empno_idx on em(empno);

alter table em add (constraint pk_em primary key (empno) using index em_empno_idx);

But I want to know what are the advantages doing this .Is it only used to make the constraint defferable or there is any other advantage also. Received on Thu Mar 16 2006 - 03:16:17 CST