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