Version : Oracle 10g
Hi ,
I have got enq: TM - contention in my database , and I want to apply the index on the foreign key column of one of the table.
But I see there are composite foreign keys as well as single foreign keys in the table.
Single foreign key I can easily create the index, but what my doubt is that , for composite foreign key ,
Do I have to create the composite index on the composite foreign key columns or on each column of composite key , I have to apply index to resolve the enq: TM - contention issue.
For Example : I have foreign key as below
| CONSTRAINT "FK_RECONDATA_DRIVER" FOREIGN KEY ("FNR", "DADDRESSTYPE", "DADDRESSNR") |
| REFERENCES "PASS"."FAZGFUEHRER" ("FNR", "ANSCHTYP", "ANSCHNR") ENABLE, |
| CONSTRAINT "FK_RECONDATA_PRODUCT" FOREIGN KEY ("FNR", "PRODUCTNR") |
| REFERENCES "PASS"."SORTE" ("FNR", "SORTENNR") ENABLE |
here FNR column is common in both the foreign key,
Please help me in finding how to create index on such columns.