use or abuse of Foreign Keys ?

An application have up to 9 indexes on a table. on of them is the primary key that most of the time includes all of the others.
I have been told that the others are there to avoid locks on children table when a delete cascade is performed on the mother.

1. can we gain an index and oracle use the FK when the first colums of a FK index is in the PK
2. when is it too heavy to use FK ?

Please, email me to atanguy_at_concept.fr

Thanks a lot Received on Wed Jul 15 1998 - 00:00:00 CDT