Query cached plan

• LeopoldNjampa

  SSC-Addicted

  Points: 473

  More actions

  March 22, 2004 at 7:45 am

  #107797

  Hi folks,

  Can anyone please tell me how to force the optimizer to NOT use any cached execution plan for a particular query! I want to check this for a query from within the query analyser (I am aware I can put this query as a stored procedure with the "WITH RECOMPILE" option or even use DBCC FREEPROCACHE)!

  Thanking you in advance for your replies.

  LeopoldNjampa

• March 25, 2004 at 8:00 am

  This was removed by the editor as SPAM

• Antares686

  SSC Guru

  Points: 125444

  More actions

  March 25, 2004 at 12:20 pm

  #500485

  I know of no other ways to do this as you are asking.