Pre-DML trigger vs Foreign keys

[Anushka Dissanayake]

Hi,
I have a query with regard to the usage of pre-dml triggers instead of foreign keys.
We have several tables with below scenario

As an example I will take 2 tables.


payments ( pid , userid , updated_user )
users (userid , username )

foreign keys
payment .userid -> users.userid
payment. updated_user -> user.userid

In this situation the payment table refers to user table for 2 foreign keys.

My senior DBA suggesting use before-insert trigger instead of 2 foreign keys.

Can any one explain me the performance difference between those 2 and what is the most suitable method.

Please direct me the relevent documents ,if you have any.
Thanking you in advance.

AD