Hello,
I have a question,maybe you know the answer.
I know if I create primary key(PK_TABLE1) of TABLE1,
Oracle will create a unique index(PK_TABLE1) for the table.
Alter table TABLE1 add constraint FK_TABLE1 foreign key (COL1)
reference TABLE2 (COL1),
I couldn't see any index object for this foreign key.
But if I create a index named FK_TABLE1 with COL1 of TABLE1,
Will it be faster in searching the TABLE1 references TABLE2??
Could anyone give me some suggestion?
Please Cc to : violin.hsiao_at_mail.pouchen.com.tw,Thank you :)
Received on Thu Jul 30 1998 - 23:21:57 CDT
