explain plan for stored procedure

Posted in 2007

Topics: Stored Procedures & SPL, Platform-Specific Issues, Versions, Editions & End-of-Life

Campbell, John (GE Money) — Tue, 10 Apr 2007 09:34:27 -0400 — source: Usenet: comp.databases.informix

IDS 9.40.FC5 Solaris 9 How do I run explain on a stored procedure (SPL)? Can it be done without executing them? thanks

↪ replying to Campbell, John (GE Money)

Superboer — 10 Apr 2007 07:46:12 -0700 — source: Usenet: comp.databases.informix

On 10 apr, 15:34, "Campbell, John \\(GE Money\\)" <John.Campbe...@ge.com> wrote: > IDS 9.40.FC5 Solaris 9 How do I run explain on a stored procedure (SPL)? Can it be done without executing them? > > thanks set explain on; update statistics for ..... Superboer,

Glossary

IDS (Informix Dynamic Server)