El 20/04/2012, a las 15:20, Nick Upson <nu@...> escribió:

> Hi,
>
> I believe that the query plan for a query in an SP is determined at the
> time the SP is defined
> - if so can I access that plan
> - can I force the plan to be recalculated (preferably without stopping
> database access)
>
>

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.

Jesus

>

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