Re: Foreign Keys as to affect impact on performance
> Does foreign key have impact on performance of the queries
No.
If a FK requires an index you would not otherwise have required, it might affect insert/update performance a little, but not much.
If you need relational integrity, you need either foreign keys or equivalent code. Often app code is a costlier way overall to implement relational integrity.
Subject
Written By
Posted
November 11, 2014 01:25PM
Re: Foreign Keys as to affect impact on performance
November 11, 2014 10:29PM
November 12, 2014 07:23PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.