Hello Helen,

>It's a 1:1 relationship, so it's very easy to implement a cascading delete
>(if wanted) and existence rules using custom triggers. Drop the FK
>relationship

Thanks for response.

So you actually suggest that I implement referential integrity using
triggers instead of FK. Unfortunatelly this implies inconsistencies in
design. Do you think that benefits of dropping the FK index worth it?
Will execution plans be better?

--
Best regards,
Alexander mailto:saho@...