Re: Set Explain with SP's

On Oct 10, 1:29pm, Jon Vemo wrote: > Subject: Set Explain with SP's > In attempting to determine how the optimizer is processing queries in > stored procedures, we've tried turning 'set explain on' within a procedure. > However, when executing the procedure, I get an empty file. > > Is there anything special which needs to be done, to get set explain output > from stored procedures?? > > Thanks > Jon Vemo > >-- End of excerpt from Jon Vemo Jon, You only get Set explain output from an SP when you create it as this is when the optimisation is done. Cheers - Jim -- ----------------------------------------------------------------------------- Jim Gordon DHL Airways Inc. jgordon@us.dhl.com ----------------------------------------------------------------------------- My opinions are my own. They may vary with time but they remain mine!