search for: bevahed

...ap, data junk. However, I''ve also learned the hard way that FKs constraints imposes serious difficulties when moving data around, specially between different DBs, or for loading test data or for upgrading DBs schemas, or for porting DBs and other special data mangling outside the well-bevahed application CRUD functionality. So, I was thinking, why is FK contraints good? For one thing, they improve performance by indexing the FK fields (at least in the good RDMSes), but that can be done independently. And then, the most obvious reason and most beneficial, they enforce data integrity...