Re: disable triggers - update stats

Posted in 2005

Topics: Stored Procedures & SPL, Triggers, Constraints & Referential Integrity

Davorin Kremenjas — Wed, 12 Oct 2005 11:18:44 +0200 — source: Usenet: comp.databases.informix

If this is not a joke then enable those triggers back as soon as you can. Because, if those triggers implement and/or enforce any kind of business logic (or call stored procedures that do the same) you can imagine what can and will happen (and maybe already did). <tomcaml@yahoo.com> wrote in message news:1129045641.152081.196710@g43g2000cwa.googlegroups.com... > hello all > > i have disabled a few triggers on production - is it necessary to run > update stats on the table the trigger was pointing to? i realize it is > not something that would be any means hurt things but is it necessary > or highly recommended? > > thanks, > tom >

↪ replying to Davorin Kremenjas

tomcaml@yahoo.com — 12 Oct 2005 14:09:15 -0700 — source: Usenet: comp.databases.informix

nope - not a trick question just a poorly designed database from years gone back - the triggers call a stored procedure which has been commented out completely, so they do nothing - thanks for the replies.....