Re: 'no row' deadlock - ORA-00060

Jonathan Lewis doodled thusly:

>
>a) Is the table involved in a parent/child relation
> where there is no index on the child table
> representing a foreign key
>

Jonathan, just a quick check:

If the FK is, say, a column called COL_FK. And there is no index on that column alone. But there is a unique index on (COL_FK,COL_SEQ). This would have the same effect in negating deadlocks as the FK index you mention above?

TIA for any feedback. This relates to work I'm currently doing and I'd appreciate the heads-up.

Cheers
Nuno Souto
nsouto_at_optushome.com.au.nospam Received on Thu Nov 29 2001 - 07:51:57 CST