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

Reply via email to