Home Forums Database Design Design Ideas and Questions Foreign Key Constraints and Performace! RE: Foreign Key Constraints and Performace!
steveb.
SSC-Forever
Points: 46733
More actions
July 5, 2010 at 4:58 am
#1188729
If you have a relational databae then you need to have FK constraints, without them you may as well look at column database.
The FK can impact perfromance, however they can also be used by the Query Optimizer for optimizing queries.