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

Hi,

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

VAST

http://download-west.oracle.com/docs...nteg.htm#11659

it it when you DML the parent table

oh ok, I understood now.

Thank you.


F.