Re: Referential indexes

From: Terry Sutton <terrysutton_at_usa.net>
Date: Fri, 28 Jan 2005 15:02:33 -0800
Message-ID: <021001c5058d$ba6a1850$6bf5a8c0@TerrySutton>

I believe that's the case, although you won't necessarily have locking issues. But there is potential.

--Terry

Original Message ----- From: "Thomas Day" <tomday2_at_gmail.com> To: <oracle-l_at_freelists.org> Sent: Friday, January 28, 2005 10:40 AM Subject: Re: Referential indexes

But the foreign key has to be the LEADING column(s), yes?

I have a foreign key on a compound primary key but the foreign keyed column is the second column in the primary key index. Am I right to think that updates will not use the index and that I will have locking issues?
--

http://www.freelists.org/webpage/oracle-l

--

http://www.freelists.org/webpage/oracle-l Received on Fri Jan 28 2005 - 18:07:24 CST