RE: Add Constraint

Posted in 2005

Bill Dare — Thu, 1 Sep 2005 08:41:28 -0400 — source: Usenet: comp.databases.informix

Yes, I assume you are correct. I always create my databases in rootdbs and then explicitly place my tables where I want them, so I always see implicitly created indexes in rootdbs. Bill > -----Original Message----- > From: Dirk Moolman [SMTP:DirkM@caretech.co.za] > Sent: Thursday, September 01, 2005 4:30 AM > To: Bill Dare > Subject: RE: Add Constraint > > Will it not be created in the dbspace that the database is in ? > > > -----Original Message----- > From: owner-informix-list@iiug.org [mailto:owner-informix-list@iiug.org] > On Behalf Of Bill Dare > Sent: 31 August 2005 03:53 PM > To: owner-informix-list@iiug.org; Colin Dawson > Cc: informix-list@iiug.org > Subject: RE: Add Constraint > > The server is going to build that index in your rootdbs so you might > want to create the index explicitly first so you can control where it > resides and then add the constraint. > > Bill > > > > -----Original Message----- > > From: owner-informix-list@iiug.org [SMTP:owner-informix-list@iiug.org] > > On Behalf Of Obnoxio The Clown > > Sent: Wednesday, August 31, 2005 8:35 AM > > To: Colin Dawson > > Cc: informix-list@iiug.org > > Subject: Re: Add Constraint > > > > Colin Dawson said: > > > > > > Sorry..... > > > > > > It's a Foreign Key constraint > > > > It may well have had to build an index, then. > > > > > Regards > > > > > > Colin > > > > > > There are 10 types of people in the world, those that understand > > binary > > > and > > > those that don't > > > > > > > > > > > > > > > > > >>From: "Obnoxio The Clown" <obnoxio@serendipita.com> > > >>To: "Colin Dawson" <cjd_1955@hotmail.com> > > >>CC: informix-list@iiug.org > > >>Subject: Re: Add Constraint > > >>Date: Wed, 31 Aug 2005 11:03:08 +0100 (BST) > > >> > > >> > > >>Colin Dawson said: > > >> > > > >> > I've just added a constraint on a table both the master and > > detail > > >>tables > > >> > have over 100M rows, and it took almost 2 hours, does anyone know > > what > > >> > exactly happens during an ADD CONSTRAINT. > > >> > > >>What kind of constraint? > > >> > > >>-- > > >> > > >>Bye now, > > >>Obnoxio > > >> > > >>"C'est pas parce qu'on n'a rien ` dire qu'il faut fermer sa gueule" > > >> - Coluche > > >> > > >>A smile is a gift that is free to the giver and precious to the > > >> recipient. > > >>But giving someone the finger is free too, and I find it more > > personal > > >> and > > >>sincere. > > > > > > > > > > > > -- > > > > Bye now, > > Obnoxio > > > > "C'est pas parce qu'on n'a rien ` dire qu'il faut fermer sa gueule" > > - Coluche > > > > A smile is a gift that is free to the giver and precious to the > > recipient. > > But giving someone the finger is free too, and I find it more personal > > and > > sincere. > > sending to informix-list > sending to informix-list sending to informix-list