Re: Referential indexes

  • From: Thomas Day <tomday2@xxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Fri, 28 Jan 2005 13:40:58 -0500

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

Other related posts: