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?
--
http://www.freelists.org/webpage/oracle-l

Follow-Ups:

Re: Referential indexes
From: Terry Sutton

References:
- RE: Referential indexes
  - From: Leonard, George
- Re: Referential indexes
  - From: Terry Sutton

Other related posts:

Browse oracle-l