RE: Speeding Up Foreign Key Creation

Posted in 2013

Ekstrand, Pamela A. -ND — Sun, 3 Feb 2013 15:51:46 -0500 — source: Usenet: comp.databases.informix

Sorry for leaving out the version. It is IDS11.70.FC5W1 on AIX 6. Thanks. Pam Eks________________________________________ From: Spokey Wheeler Gmail [spokey.wheeler@gmail.com] Sent: Sunday, February 03, 2013 3:45 PM To: Ekstrand, Pamela A. -ND Cc: Informix List - IIUG Subject: Re: Speeding Up Foreign Key Creation On 2 Feb 2013, at 23:41, "Ekstrand, Pamela A. -ND" <Pamela.A.Ekstrand.-ND@disney.com> wrote: > Does anyone have any suggestions for how to make foreign key creations run faster for very large tables? We are migrating a large XPS database to IDS. The data loads, index and primary key creates are running fast, but the foreign key creation statements take forever on the large tables. > Version? I seem to recall a product defect, but I _thought_ it had been patched.