Hi,

If I am given a choice creating a primary key on the table versus a unique index on the table what should be preferred.

I am aware of the differences between the primary key and unique indexes.

Eg:

create table Test(T1 number not null, T2 varchar2(10),
primary key(T1));

or

create table Test(T1 number unique not null, T2 varchar2(10));

I have my entire schema with Primary Key indexes and not a single foreign key.

Does Oracle create a different index structure for a primary key and unique constraints. Will there be any performance issues.


Thanks in Advance