Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Foreign_Key / Primary_Key
Maybe an obvious but not so obvious question...
If I create a foreign_key (FK_xxx) for a table with a primary_key (PK_xxx) ... does it matter whether I create a concatenated key or do I need a seperate index to match the FK?
Table A - w/unique index on (corpid, name)
Table B - fk to Table A (corpid)
I shouldn't have to go through the trouble to have 2 indexes on Table A... one with the primary / unique concatenated index and another index just on the corpid?
-Mike Received on Tue May 12 1998 - 23:19:20 CDT