On Thu, Aug 28, 2003 at 06:15:57PM +0100, 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?

Almost certainly.  But there's probably room for some middle ground
between 20 and none.


Andrew Sullivan                         204-4141 Yonge Street
Liberty RMS                           Toronto, Ontario Canada
<[EMAIL PROTECTED]>                              M2P 2A8
                                         +1 416 646 3304 x110

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
    (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])

Reply via email to