Re: stored procs and recompiling

Posted in 2000

Obnoxio The Clown — Thu, 02 Nov 2000 22:13:27 GMT — source: Informix-list mailing list archive (1991-1998)

From: "Mike Talbot" <michael.talbot@verizon.com> > >IDS 7.3x on HPUX 10.2 > >Should stored procedures be recompiled on a periodic basis? > >We have a case where a procedure was taking 10 minutes , we then created >the >same procedure w/ a new name and it took 5 seconds. > >The tables involved do have records inserted/updated at a high frequency >and >are reindexed by our DBAs once a month. I am wondering if we should drop >all >procs and recreate them after this reindexing process. UPDATE STATISTICS...._________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. Share information about yourself, create your own public profile at http://profiles.msn.com.