Re: Default Indexes with Foriegn Keys

Any indexes that I have ever created for constraint purpose, I have always created the index and then the constraint. This has been the recommended way discussed previously in this list. See prior discussion on creating indexes and constraints. C.L. Kendricks kcheryl@notes.heb.com mickm%netcom.com@heb.com on 07/08/97 02:21:52 PM Please respond to mickm@netcom.com To: informix-list@rmy.emory.edu cc: (bcc: KENDRICKS CHERYL/HEB45) Subject: Default Indexes with Foriegn Keys hi all, what do people do about the indexes created by foriegn keys? these can end up being a lot of overhaed on large tables, significantly hurting inserts and deltes, not to mention the optimizer choosing wrong indexes for queries. i have heard people say that they don't use foriegn keys in informix for this reason, yet obviously that defeats the purpose of referential integrity. any comments? mickm -- ___________________________________________________________________________ __ Mickey Mestel mickm@netcom.com -on a beach in thailand to a beautiful, stoned, norwegian woman: "..yeah, it's just another foreign country without ice." --------------------------------------------------------------------------- --