The index will not be used by the add constraint unless it is on ONLY
the column(s) in the constraint. So, if you have a composite index with
your constraint column as the lead column in the index, that index will
not be used for the constraint. The server will create a new index.

Bill


> -----Original Message-----
> From: owner-informix-list@iiug.org [SMTPwner-informix-list@iiug.org]
> On Behalf Of Colin Dawson
> Sent: Wednesday, August 31, 2005 8:51 AM
> To: obnoxio@serendipita.com
> Cc: informix-list@iiug.org
> Subject: 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
sending to informix-list