Home -> Usenet -> comp.databases.theory -> Re: Should I use database foreign keys and indexes

Re: Should I use database foreign keys and indexes

From: Carl <carl.stottlemyer_at_lmco.com>
Date: 16 Jul 2002 06:04:55 -0700
Message-ID: <bc814416.0207160504.4f647876_at_posting.google.com> 






Thanks for all of your input.  I am going to present to the group
today why they should use idexes as a primary key and have foreign key
constraints.  Most of the opposition for foreign key constraints seem
to think it is a hassle to turn them on and off when you are doing
mass updates and/or need to repair the database.  Personally I think
that if you are doing mass imports or need to repair the database that
is when you need them the most because you don't have any control over
the integrity of the data being imported and during repairs you have
the greatest potential to break something else.
Received on Tue Jul 16 2002 - 15:04:55 CEST












Original text of this message