Home » SQL & PL/SQL » SQL & PL/SQL » Use index to minimize the lock on parent table (Oracle 11g)
Use index to minimize the lock on parent table [message #580750] Wed, 27 March 2013 13:16 Go to next message
ashwani0301
Messages: 44
Registered: March 2013
Location: Karnatka, Bangalore
Member
I want to know that what oracle server do to minimize the lock on parent table,
when we use Index on foreign key column ???? Shocked
Re: Use index to minimize the lock on parent table [message #580752 is a reply to message #580750] Wed, 27 March 2013 13:50 Go to previous messageGo to next message
Michel Cadot
Messages: 57648
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
This is explained in Database Concepts.
You can also read 'And Something "Unlearned"' section at bottom of http://www.oracle.com/technetwork/issue-archive/2010/10-nov/o60asktom-176254.html.

Regards
Michel

[Updated on: Wed, 27 March 2013 14:12]

Report message to a moderator

Re: Use index to minimize the lock on parent table [message #580754 is a reply to message #580752] Wed, 27 March 2013 14:11 Go to previous message
ashwani0301
Messages: 44
Registered: March 2013
Location: Karnatka, Bangalore
Member
Thanks Michel
Previous Topic: Returning first rank after aggregating
Next Topic: Variable value is not being recongnize
Goto Forum:
  


Current Time: Thu Apr 24 14:15:18 CDT 2014

Total time taken to generate the page: 0.28214 seconds