RE: Mysterious !! - Stored Procs Slowing Down

David The stored procedure is optimized at the time it is created or every = time you run the UPDATE STATISTICS for the procedure. That means that if = it did an operation for a table, its query plan would depend on the = number of rows in the table, for example. My guess is that the number of = rows in the table are changing so much that the query plan for the = stored procedure becomes obsolete. Try adding the UPDATE STATISTICS for = procedure to your UPDATE STATISTICS process that you run regularly. HTH Sujit Pal ---------- From: David Lapsley[SMTP:davidl@enterprise.net] Sent: Tuesday, January 13, 1998 4:05 AM To: informix-list@rmy.emory.edu Subject: Mysterious !! - Stored Procs Slowing Down We have a number of stored procedures which normally take < 1 sec to = run. After a few days of running correctly they begin to take > 10 mins to = run. (NOT a gradual degradation, either 1sec OR 10mins, no in between) The only method of resolving the problen is to DROP and RE-CREATE the offending procedure. Running update statistics does not help. We are running SE 7.20.UC2 on SCO Openserver Release 5 (INTEL). Any ideas greatly appreciated, its becoming a major headache. Thanks in advance David Lapsley