Re: Foreign Keys as to affect impact on performance
Posted by: Peter Brawley
Date: November 11, 2014 10:29PM

> 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.

Options: ReplyQuote


Subject
Written By
Posted
Re: Foreign Keys as to affect impact on performance
November 11, 2014 10:29PM


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.