Disable Constraint

Posted in 2006

Colin Dawson — Thu, 14 Dec 2006 14:28:54 +0000 — source: Usenet: comp.databases.informix

What does Informix do when you disable a constraint? I'm running one on a 188M row table and it is doing a lot of reads (over 1M so far) I though all it had to do was change the state column in sysobjstate to 'D' Regards Colin There are 10 types of people in the world, those that understand binary and those that don't _________________________________________________________________ Be the first to hear what's new at MSN - sign up to our free newsletters! http://www.msn.co.uk/newsletters

↪ replying to Colin Dawson

bozon — 14 Dec 2006 07:52:31 -0800 — source: Usenet: comp.databases.informix

I making sure that non of the rows do not not violate the constraint. ;-) This is very interesting. I hope someone has a good answer. I would like to know also. Colin Dawson wrote: > What does Informix do when you disable a constraint? > > I'm running one on a 188M row table and it is doing a lot of reads (over 1M > so far) I though all it had to do was change the state column in sysobjstate > to 'D' > > > > > Regards > > Colin > > There are 10 types of people in the world, those that understand binary and > those that don't > > _________________________________________________________________ > Be the first to hear what's new at MSN - sign up to our free newsletters! > http://www.msn.co.uk/newsletters