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." -----------------------------------------------------------------------------