"inna" <me****@hotmail.com> wrote in message
news:34**************************@posting.google.c om...
How can I change procedure cache values.
Is it possible to change them only for one procedure.
If I have a huge procedure and small one I would like to allocate
values for both of them accordingly.
You can't - MSSQL creates execution plans and manages the procedure cache
automatically. You can recompile a procedure, which forces MSSQL to create a
new plan (for example, after adding a new index), and you can empty the
entire cache, but that's about it. Check out "Execution Plan Caching and
Reuse" in Books Online for more details on how the cache works.
If you're having a specific problem, perhaps you could give some more
information, and someone may be able to suggest something.
Simon