-
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|