Re: stored procs and recompiling

Mike Talbot wrote: > > 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. Have you tried UPDATE STATISTICS FOR PROCEDURE? Cheers, -- Mark. +----------------------------------------------------------+-----------+ | Mark D. Stock mailto:mdstock@mydas.freeserve.co.uk |//////// /| | http://www.informix.com http://www.informixhandbook.com |///// / //| | http://www.iiug.org +-----------------------------------+//// / ///| | |This email will self-destruct in |/// / ////| | |10 sec. If you received this email |// / /////| | |in error, sorry about the mess. |/ ////////| +----------------------+-----------------------------------+-----------+