RE: Add Constraint
This is a discussion on RE: Add Constraint within the Informix forums, part of the Database Server Software category; --> The server is going to build that index in your rootdbs so you might want to create the index ...
| |||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
04-20-2008, 10:06 AM
| ||||
| ||||
 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  wner-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      |
Linear Mode
