On Thu, 28 Aug 2003, teknokrat wrote: > I have a table that has about 20 foreign key constraints on it. I think > this is a bit excessive and am considering removing them ( they are all > related to the same table and I don't think there is much chance of any > integrity violations ). Would this improve performance or not?
It depends on your frequency of inserts/updates to the table with the constraint and the frequency of update/delete to the table(s) being refered to. My guess is probably. You may wish to leave some of the constraints (decide which are the most important), but 20 does seem a bit excessive in general. ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster