How does oracle avoid dead lock when I create an index on the foreign key column?
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

Answer Question   |  October 22, 2010  7:22 AM
Database deadlock, Index and Key, Oracle developers, Oracle queries, Oracle Query

SQL Server: Index and Key
What is the difference between a key and an index? Whe I issue a SELECT statement, and the table has an index, do I still have to use my key?

Answer Question   |  August 3, 2009  5:08 PM
Index and Key, SELECT statement