Hi,

Can someone tell me whether or not, generally, that NOT having foreign key constraints is a good idea or not?

We first had a database that did have foreign key constraints and now we don't...since the fkeys were removed, the database works better.

I know it depends on the database and the data, etc. But, is there a general perception in the dba world whether or not foreign keys should at least try to be used in order to maintain data integrity?

Zoey