Re: Lock timeout on oracle 8i

The other issue of not indexing the child foreign key is that deleting the parent row causes a full table scan on the child table, if the constraint is cascade on delete. (If not cascade, then of course there won't be a delete on the parent).

Yong Huang

"Howard J. Rogers" <dba_at_hjrdba.com> wrote in message news:<ad14og$go2$1_at_lust.ihug.co.nz>...
> The rule with foreign key relationships ought to be, as a result, slap an
> index on the child table's foreign key column to avoid painful locking
> issues. Unless you aren't using Oracle Forms, or unless you can otherwise
> guarantee that no parent key will ever be updated.
>
> Regards
> HJR
Received on Wed May 29 2002 - 13:21:11 CDT