Add Constraint

Posted in 2005

Colin Dawson — Wed, 31 Aug 2005 09:23:43 +0000 — source: Usenet: comp.databases.informix

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

↪ replying to Colin Dawson

scottishpoet — 31 Aug 2005 05:31:47 -0700 — source: Usenet: comp.databases.informix

maybe the database is building some indexes and checing there are no violations?