March 22, 2010 at 8:49 am
Hi,
we are using SQL 2005 and want to keep the fixed execution plan not being recompile regardless of any statistics changes. What's the syntax of approaching this?(For SQL 2000 it's 'OPTION(KEEPFIXED PLAN)' but for SQL 2005 we dunno yet) Thanks a lot.
Thanks and regards,
Wallace Chan
March 22, 2010 at 8:56 am
You can do the same with SQL Server 2005.
You also have the option of provide plan guides. Here's an introduction on the topic from Microsoft.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy