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