Need suggestion on Foreign Keys

Posted in 2006

Topics: Triggers, Constraints & Referential Integrity

Prashant Shirude — Fri, 3 Mar 2006 11:21:48 -0500 — source: Usenet: comp.databases.informix

Hi All, I have 2 tables which has 10 Million records and defined Primary Keys. I need best approach and which will be the fastest process. 1) Create all required Indexes on both tables and then create Foreign Keys. OR 2) Create Foreign Keys and then create all required indexes on it. Thanks,Prashant

↪ replying to Prashant Shirude

Paul Watson — Sat, 4 Mar 2006 17:01:36 -0600 — source: Usenet: comp.databases.informix

Personally I go for the former, I like to name indices myself, allows me to scripts things a lot easier Paul Watson Tel: +44 1414161772 Mob: +44 7818003457 GO FURTHER with DB2 GET THERE FASTER with Informix. Attend the IDUG 2006 North America Conference. Tampa, Florida, USA. 7-11 May 2006. Visit http://www.iiug.org/conf for more information. > -----Original Message----- > From: Prashant Shirude [mailto:PShirude@manh.com] > Posted At: Friday, March 03, 2006 10:22 AM > Posted To: comp.databases.informix > Conversation: Need suggestion on Foreign Keys > Subject: Need suggestion on Foreign Keys > > > Hi All, > > I have 2 tables which has 10 Million records and defined Primary Keys. > > I need best approach and which will be the fastest process. > > 1) Create all required Indexes on both tables and then create Foreign > Keys. > OR > 2) Create Foreign Keys and then create all required indexes on it. > > Thanks,Prashant