Translating with DrWatson… this can take a few seconds the first time.
This is a genuine, complex translation. DrWatson protects commands, error codes, and log output while naturally translating the surrounding text. It’s translated once and saved.
Mark D. Stock — — source: Informix-list mailing list archive (1991-1998)
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.comhttp://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. |/ ////////|
+----------------------+-----------------------------------+-----------+
We use strictly necessary cookies to make this site work. With your
consent we’d also use optional cookies for analytics and marketing. You can accept all,
reject all, or choose. Read our Cookie Policy.