Re: How many FKs is too many ?

Best pratice is to:
a) normalise your design
b) define FK constraints for all columns where it makes sense to do so

The number of FKs is determined by the design, not by an arbitrary cut-off like 15.

No, it won't cause poor performance. Each FK will have some small impact on inserts, updates and deletes - but that's better than the alternative, which is a corrupt database. Received on Thu Oct 21 2004 - 07:15:13 CDT