Re: Stored Procedure and SET EXPLAIN

Posted in 1998

WF Software — 16 Jul 1998 20:29:57 GMT — source: Informix-list mailing list archive (1991-1998)

In article <6olan0$2r3$1@duke.telepac.pt>, denis@ferseque.pt (Denis Heliszkowski) wrote: > I hav a stored procedure and I think that it's slow... I'd like to > improve > it's performance. > > But how can I use SET EXPLAIN with stored procedure to see the costs > and all > that stuff that I can see when using a normal query ? > > Thanks in advance, > Denis Heliszkowski. > > > Yes but you need to put it outside the create procedure code, and you'll get an sqexplain.out when the SPL is built Paul Watson WF Software Ltd. Tel. (+44) 1436 674729 Fax. (+44) 1436 678693