Add this to what Arup said:
PK enables one to have References established in a schema. (Parent Child
relationships i mean). That cannot be done just by having a unique
and/or
not null constraints set.
You will get ORA-02270: no matching unique or primary key for this
column-list
HTH
GovindanK
Govindan,
You can create FK relationship(Parent-child) by using UNIQUE constraint..
Correct me if I am wrong.
-Original Message-
Sent: Thursday, January 22, 2004 6:37 PM
To: Multiple recipients of list ORACLE-L; Multiple recipients of list
ORACLE-L
Cc: [EMAIL PROTECTED]
Add this to
is more efficient? When should I go for option (1)?
1)NON-UNIQUE index Vs Unique Constraint
drop table index_test;
create table index_test(c1 number,c2 varchar2(20));
create index i1 on index_test(c1);
alter table index_test add constraint index_test_uk1 UNIQUE(c1);
2)UNIQUE index Vs Unique
-UNIQUE index Vs Unique Constraint
drop table index_test;
create table index_test(c1 number,c2 varchar2(20));
create index i1 on index_test(c1);
alter table index_test add constraint index_test_uk1 UNIQUE(c1);
2)UNIQUE index Vs Unique Constraint
drop table index_test;
create table index_test(c1 number
Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Saturday, January 17, 2004 3:14 AM
All,
Please enlighten this Junior DBA.
Which method is more efficient? When should I go for option (1)?
1)NON-UNIQUE index Vs Unique Constraint
drop table index_test;
create
://www.jlcomp.demon.co.uk/faq/ind_faq.html
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Saturday, January 17, 2004 3:14 AM
All,
Please enlighten this Junior DBA.
Which method is more efficient? When should I go for option (1)?
1)NON-UNIQUE index Vs Unique
3:14 AM
All,
Please enlighten this Junior DBA.
Which method is more efficient? When should I go for option (1)?
1)NON-UNIQUE index Vs Unique Constraint
drop table index_test;
create table index_test(c1 number,c2 varchar2(20));
create index i1 on index_test(c1);
alter table
All,
Please enlighten this Junior DBA.
Which method is more efficient? When should I go for option (1)?
1)NON-UNIQUE index Vs Unique Constraint
drop table index_test;
create table index_test(c1 number,c2 varchar2(20));
create index i1 on index_test(c1);
alter table index_test add constraint