OPTION(KEEPFIXED PLAN) for SQL 2005?

• Chan Wai Yin

  SSCommitted

  Points: 1883

  More actions

  March 22, 2010 at 8:49 am

  #218433

  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

• Grant Fritchey

  SSC Guru

  Points: 398690

  More actions

  March 22, 2010 at 8:56 am

  #1137631

  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