locks and fk
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: locks and fk

  1. #1
    Join Date
    Dec 2001
    Location
    Brazil
    Posts
    282

    locks and fk

    I've read recently that if foreign key columns suffer lots of updates we should put a index to avoid locks (it's written that a simple update we run against a row may lock all the table causing contention). I cant understand why exatcly a index in the fk cols can avoid this 'lock all the table'. May someone explain it please?


    Thanks in advance.


    F

  2. #2
    Join Date
    Dec 2002
    Location
    India & Australia
    Posts
    68

    locks and fk

    Hi,

    Could you eloborate for which version you are exchanging this parameter bug?

    VAST

  3. #3
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,448
    http://download-west.oracle.com/docs...nteg.htm#11659

    it it when you DML the parent table

  4. #4
    Join Date
    Dec 2001
    Location
    Brazil
    Posts
    282
    oh ok, I understood now.

    Thank you.


    F.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width