Hello I Am Gurpreet Singh Sethi Working As A DBA. At My Work Place We Are Running A Gurgaon Based Company's ERP Package. In That Package We Have A Table MRN . Let Me Discribe

Gate Entry Code Is refered In MRN Table
Mrncode Is refered In Debit Note Table
Mrncode Is refered In VOucher Table
Mrncode Is refered In Material Issue Table

So As A Whole MRN Is The main Table Refered At Several Other table By FOreign Key. When Ever sone One Do any Thing On Mrn Table All Other Table Get Locked And Soon Results In Dead Lock Situation. I have Alredy make Indexes On Reference Keys

All Hit Ratios are fine and up to the mark.


Any Suggetion