SQL Server RECOMPILE Query Option

22 Dec
December 22, 2011

A simple example on SQL Server’s RECOMPILE query option.

the RECOMPILE Query Option directs SQL Server to generate a new Query Execution Plan every time the query is run, the syntax for the command is:


Being a Query Option, the RECOMPILE statement needs to be placed at the end of the query, as such:

    dbo.Transactions T WITH (INDEX(IDX_Customer_2))
    CustomerID = 1

Usually forcing SQL Server to regenerate a plan is needed in the following situations:

  • SQL Server Query Processor engine is not generating the expected efficient plans due to plan generalization.
  • Catch-all queries such as using ISNULL in the WHERE clause
          0 votes
0 replies

Leave a Reply

Want to join the discussion?
Feel free to contribute!

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>