Stored Procedure Optimizer Problem

Posted in 1999

Topics: Performance & Tuning, Stored Procedures & SPL

Drew — Mon, 22 Mar 1999 09:04:23 -0600 — source: Informix-list mailing list archive (1991-1998)

Readers, Why would the execution of a stored procedure continually cause a re-optimization, locking sysprocplan in the process? Tried update statistics high on all tables and the procedure. The only thing that seems to disrupt this irritation is setting optimization to low! This behaviour causes major problems in a multi-user environment; turns the application into a single user app. Please Advise, Regards Drew.

↪ replying to Drew

David Williams — Mon, 22 Mar 1999 22:56:54 +0000 — source: Informix-list mailing list archive (1991-1998)

In article <7d5m9o$kpi$1@nntp.gulfsouth.verio.net>, Drew <andrew.simpson @matcomcorp.com> writes >Readers, > >Why would the execution of a stored procedure continually >cause a re-optimization, locking sysprocplan in the process? > >Tried update statistics high on all tables and the procedure. > >The only thing that seems to disrupt this irritation is setting >optimization to low! > >This behaviour causes major problems in a multi-user >environment; turns the application into a single user app. > >Please Advise, >Regards Drew. > > Check the FAQ at www.smooth1.demon.co.uk -- David Williams

Glossary

UPDATE STATISTICS