Home > IT Answers > Database > How does oracle avoid dead lock when I create an index on the foreign key column?
Gangadhar26
10 pts.
 How does oracle avoid dead lock when I create an index on the foreign key column?
Database deadlock, Index and Key, Oracle developers, Oracle queries, Oracle Query
How does oracle avoid dead lock when we create an idex on the foreign Key column ? Found many experts say this, but i never really found what is the logic behind this. So any replies provided are appreciated . thanks in advance gangadhar

Software/Hardware used:
oracle 10g
ASKED: October 22, 2010  7:22 AM
UPDATED: October 22, 2010  2:52 PM
RELATED QUESTIONS
Answer Wiki:
Last Wiki Answer Submitted:  Be the first to answer this question.
All Answer Wiki Contributors:  Be the first to answer this question.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

Why do you think the database engine needs to do something to avoid deadlocks when creating an index ?

Can you explain your doubt with a little more detail, please ?

carlosdl
 63,535 pts.