Re: Referential indexes

  • From: "Terry Sutton" <terrysutton@xxxxxxx>
  • To: <oracle-l@xxxxxxxxxxxxx>
  • Date: Fri, 28 Jan 2005 15:02:33 -0800

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@xxxxxxxxx>
To: <oracle-l@xxxxxxxxxxxxx>
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?
--
//www.freelists.org/webpage/oracle-l


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

Other related posts: