RE: Set Explain with SP's

> > Jon, > > Because procedures are optimized when they are stored in the database, > that is when you need to set explain on. For example: > > SET EXPLAIN ON;> CREATE PROCEDURE... > > The "SET EXPLAIN ON" must appear outside of your create procedure. Its my impression that an UPDATE STATISTICS on a procedure will update the optimization plan for the procedure - which may change the query strategy. cheers j. _____________________________________________________________________________ Jack Parker - Hewlett Packard, DMD/IS Boise, Idaho, USA jparker@hpbs3645.boi.hp.com _____________________________________________________________________________ Lysdexics Untie! _____________________________________________________________________________ Any opinions expressed herein are my own and not those of my employers. _____________________________________________________________________________