Colin

You do not say which type of constraint you have created, however in
general an index must be created to support the constraint (unique if
needed). Even if an index exists if there is more than one field in
the constraint (for a primary key perhaps) then every field must be
checked to ensure it is not null. Obviously if there is a referential
constraint then each row in the detail must be referred back to the
master to ensure it exists.
Any help??
If not what precisely are you doing.

Keith

-> -----Original Message-----
-> From: Colin Dawson [mailto:cjd_1955@hotmail.com]
-> Sent: Wednesday, August 31, 2005 10:24 AM
-> To: informix-list@iiug.org
-> Subject: Add Constraint
->
->
-> 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.
->
->
->
->
-> Regards
->
-> Colin
->
-> There are 10 types of people in the world, those that
-> understand binary and
-> those that don't
-> sending to informix-list
->

************************************************** ********************************
This message is sent in strict confidence for the addressee only. It may
contain legally privileged information. The contents are not to be disclosed
to anyone other than the addressee. Unauthorised recipients are requested
to preserve this confidentiality and to advise the sender immediately of any
error in transmission.
This footnote also confirms that this email message has been swept for the
presence of computer viruses, however we cannot guarantee that this message
is free from such problems.
************************************************** ********************************
sending to informix-list