|
-
Tamilselvan,
I understand, it locks the child table record when we delete partent record(ON DELETE CASCADE). Why we need index on FK's? I am not really understand why we need index on FK's. Can you please explain.
Govind
 Originally Posted by tamilselvan
NO.
Indexes on FK are needed otherwise you will have locking issues.
Tamil
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
|
Reply With Quote