Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> Foreign Key and Unique key on same columns
Hi,
Is there any performance problem if two columns have FOREIGN KEY from different tables and both columns also have UNIQUE CONSTRAINT?
CREATE TABLE table1 ( COL1 NUMBER constraint table1_fk1 references table2(col1), COL2 NUMBER constraint table1_fk2 references table3(col1)); CREATE UNIQUE INDEX table1_uq1 ON table1(COL1, COL2);
Thanks
Muqthar Ahmed
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Muqthar Ahmed
INET: Muqthar.Ahmed_at_decoratetoday.com
Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services ---------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Tue Oct 28 2003 - 15:24:25 CST