-
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?
Why?
-
Yes. This is a fairly well-known 'issue' (ie BUG in my book ) in Oracle.
Here is a link for you:
http://oradoc.photo.net/ora8doc/DOC/...1/ch6.htm#1574
...and here is a previous thread where we discussed the issue:
http://www.dbasupport.com/forums/sho...?threadid=7857
HTH,
- Chris
-
>create index on Foreigh key in child? Is this true?
Yes this is true
Why?
Because when oracle delete a row it look for every child row.
If exist an index this is faster.
-
Thank you!
Chris, your links are very helpful!
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|