Always index all FK columns (see application developers guide). Briefly, Oracle will place exclusive table level locks on child tables during parent table DML operations if there are no FK indexes. This greatly reduces concurrency. Bert Scalzo Received on Thu Jan 08 1998 - 00:00:00 CET
Briefly, Oracle will place exclusive table level locks on child tables during parent table DML operations if there are no FK indexes. This greatly reduces concurrency.
Bert Scalzo Received on Thu Jan 08 1998 - 00:00:00 CET
Original text of this message