How to eliminate implicit share locking on a child table when delete statements are issued against the parent table?
create index on Foreigh key in child? Is this true?
Yes. This is a fairly well-known 'issue' (ie BUG in my book ) in Oracle.
Here is a link for you:
...and here is a previous thread where we discussed the issue:
>create index on Foreigh key in child? Is this true?
Yes this is true
Because when oracle delete a row it look for every child row.
If exist an index this is faster.
Chris, your links are very helpful!
Click Here to Expand Forum to Full Width