July 31, 2003 at 7:57 am
Hi!
Have an application that creates all needed temporary tables for each user as it starts.
The procedures, that use these temp tables are always recompiled since the tables were created not by these procedures.
Is there a way to force MS SQL (MS SQL Server 2000 SP3) not to recompile the procedures?
Thanks.
P.S.: as far as I know "keep plan" option works ONLY for "more than six times change" case.
August 1, 2003 at 5:39 am
Have you seen this?
http://www.sql-server-performance.com/rd_optimizing_sp_recompiles.asp
There is a good article on performance and sp_recompilation.
Just thought it might help..
August 1, 2003 at 5:52 am
2rajeshpatavardhan:
It says nothing about how to stop recompilation in my case. If this is full
information, I am affraid, I will only have to consider how to change the way the application works.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply