Is there an equivalent of "OPTION(RECOMPILE)" or "WITH RECOMPILE" for an entire connection?
Posted
by kamens
on Stack Overflow
See other posts from Stack Overflow
or by kamens
Published on 2010-04-07T15:31:03Z
Indexed on
2010/04/07
15:33 UTC
Read the original article
Hit count: 358
I'm curious. Is there any way to prevent SQL query execution plans from being cached for an entire connection's duration?
Can I run a command that basically says, "use OPTION(RECOMPILE) for all subsequent commands until I tell you to stop doing so?"
I'm acutely aware of all the performance trade-offs here, and I know this is not a step to be taken lightly. However, I'm in a unique situation where this behavior may be advantageous.
© Stack Overflow or respective owner