SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
04-20-2008, 09:06 AM
| ||||
| ||||
 Re: Add Constraint > > It's a Foreign Key constraint > >It may well have had to build an index, then. Nope, that isn't the problem. There is an index on the appropriate column in both tables. > > > 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      |
Linear Mode
