Unless I'm totally mistaken, FKs themselves don't offer any performance improvements. FKs that have an index on them, will be faster, but only because of the index.
FKs, or referential integrity, basically enforce the design intent. Like others have already said, you can't always count on a single application being the only interface into the database. You should keep the rules as far down as possible. M!ke -----Original Message----- From: Jennifer Larkin [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 27, 2005 2:20 PM To: CF-Community Subject: Re: Relations in the db Does he have defined primary keys at all? Primary keys are a huge performance benefit. Foreign keys are probably a benefit too, but I don't know that for sure. The main reason that I would define it is referential integrity. You can't be guaranteed that the VB application is flawless. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Find out how to get a fax number that sends and receives faxes using your current email address http://www.houseoffusion.com/banners/view.cfm?bannerid=64 Message: http://www.houseoffusion.com/lists.cfm/link=i:5:166845 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/5 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:5 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.5 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
