On 20 April 2012 16:50, Ann Harrison <aharrison@...> wrote:

> **
>
>
> 2012/4/20 Jesús García <jegaza@...>
>
> >
> > >
> > I think is defined when the SP is loaded and compiled for the first use.
> > To force a new plan, may be 2 ways, depending on the server architecture.
> >
> > 1. Superserver, recompile
> > 2. Classic/superclassic. Disconnect and connect.
> >
>
> That's right - of course, restarting Superserver also works, but that's
> overkill.
>

so the plan is not stored anywhere in the database that I can access?

what happens is this regard when some clients reconnect and others don't,
different processes could have different plans?


Nick Upson


[Non-text portions of this message have been removed]