Any and all keys create indexes, which do speed things up. SQL Server will create indexes at Statement compile time, however they are not as good as predefined ones.
And it makes the diagrams that much cooler :) > -----Original Message----- > From: Jennifer Larkin [mailto:[EMAIL PROTECTED] > Sent: Wednesday, July 27, 2005 3: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. > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Now thereâs a better way to fax. eFax makes it possible to use your existing email account to send and receive faxes. Try eFax free. http://www.houseoffusion.com/banners/view.cfm?bannerid=63 Message: http://www.houseoffusion.com/lists.cfm/link=i:5:166807 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=89.70.5 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
