Some constraints are implemented via indexes... maybe someone got created.

J.

-------- Mensaje original --------
Asunto: Add Constraint
Fecha: Wed, 31 Aug 2005 09:23:43 +0000
De: Colin Dawson <cjd_1955@hotmail.com>
Para: informix-list@iiug.org

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
sending to informix-list